thanks a lot that worked!
________________________________ From: Rodrigo <[email protected]> To: Rajeev Prasad <[email protected]>; DBIx::Class user and developer list <[email protected]> Cc: mysql list <[email protected]> Sent: Saturday, August 11, 2012 11:12 AM Subject: Re: [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 <[email protected]> wrote: 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| >|rt54| > > >after that match row with id='rt54' should be returned. > > >i am not able to figure the sql statement for this? eventually i want to have >DBIx statement to use in my perl code. So either suggestion will work for me. > > >ty.Rajeev > >_______________________________________________ >List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class >IRC: irc.perl.org#dbix-class >SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ >Searchable Archive: http://www.grokbase.com/group/[email protected] >
