[Dbix-class] search any matching word in given string in table column which has only one word

2012-08-11 Thread Rajeev Prasad
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|

Re: [Dbix-class] search any matching word in given string in table column which has only one word

2012-08-11 Thread Rodrigo
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

Re: [Dbix-class] search any matching word in given string in table column which has only one word

2012-08-11 Thread Rajeev Prasad
: [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