here is given string of type:... as23,rt54,yh79
and i have to lookup in a table which has column id which has only one four
letter word. i have to select that row in which the colum 'id' value matches
any of the word in given string...
table column: id
contents like:
| id|
|sd32|
|wa32|
Maybe something like this will do:
my $str = 'as23,rt54,yh79';
$schema-resultset('MyTable')
-search({ id=[ split /,/ = $str ] });
regards,
rodrigo
On Sat, Aug 11, 2012 at 6:05 PM, Rajeev Prasad rp.ne...@yahoo.com wrote:
here is given string of type:... as23,rt54,yh79
and i have to
: [Dbix-class] search any matching word in given string in table
column which has only one word
Maybe something like this will do:
my $str = 'as23,rt54,yh79';
$schema-resultset('MyTable')
-search({ id=[ split /,/ = $str ] });
regards,
rodrigo
On Sat, Aug 11, 2012 at 6:05 PM, Rajeev Prasad