and return an instance of C<My::Schema::Album> that represents this
row. Once you have that row, you can access and update columns:
- $album->name('Physical Graffiti');
+ $album->title('Physical Graffiti');
my $title = $album->title; # holds 'Physical Graffiti'
If you prefer, you can use the C<set_column> and C<get_column>
We also provide a handy shortcut for doing a C<LIKE> search:
# Find albums whose artist starts with 'Jimi'
- my $rs = MyApp::DB::Album->search_like({ artist => 'Jimi%' });
+ my $rs = $schema->resultset('Album')->search_like({ artist => 'Jimi%' });
Or you can provide your own handmade C<WHERE> clause, like: