From: Rajeev Prasad Date: August 11 2012 5:24pm Subject: Re: [Dbix-class] search any matching word in given string in table column which has only one word List-Archive: http://lists.mysql.com/mysql/227986 Message-Id: <1344705870.92705.YahooMailNeo@web161704.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-816086408-142114501-1344705870=:92705" ---816086408-142114501-1344705870=:92705 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable thanks a lot that worked!=0A=0A=0A=0A=0A________________________________=0A= From: Rodrigo =0ATo: Rajeev Prasad ; DBIx::Class user and developer list = =0ACc: mysql list =0ASent: Saturday, August 11, 201= 2 11:12 AM=0ASubject: Re: [Dbix-class] search any matching word in given st= ring in table column which has only one word=0A =0A=0AMaybe something like = this will do:=0A=0Amy $str =3D 'as23,rt54,yh79';=0A>$schema->resultset('MyT= able')=0A>=A0 =A0->search({ id=3D>[ split /,/ =3D> $str ] });=0A=0Aregards,= =0Arodrigo=0A=0A=0AOn Sat, Aug 11, 2012 at 6:05 PM, Rajeev Prasad wrote:=0A=0Ahere is given string of type:...=A0=A0 "as23,rt54,y= h79"=0A>and i have to lookup in a table which has column "id" which has onl= y one four letter word. i have to select that row in which the colum 'id' v= alue matches any of the word in given string... =0A>=0A>table column: id=0A= >contents like:=0A>| id|=0A>----=0A>|sd32|=0A>|wa32|=0A>|rt54|=0A>=0A>=0A>a= fter that match row with id=3D'rt54' should be returned.=0A>=0A>=0A>i am no= t 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.= =0A>=0A>=0A>ty.Rajeev=0A>=0A>______________________________________________= _=0A>List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class=0A>= IRC: irc.perl.org#dbix-class=0A>SVN: http://dev.catalyst.perl.org/repos/bas= t/DBIx-Class/=0A>Searchable Archive: http://www.grokbase.com/group/dbix-cla= ss@stripped=0A> ---816086408-142114501-1344705870=:92705--