thanks a lot that worked!
________________________________
From: Rodrigo <rodrigol...@gmail.com>
To: Rajeev Prasad <rp.ne...@yahoo.com>; DBIx::Class user and developer list
<dbix-class@lists.scsys.co.uk>
Cc: mysql list <my...@lists.mysql.com>
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 <rp.ne...@yahoo.com> 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/dbix-class@lists.scsys.co.uk
>_______________________________________________
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/dbix-class@lists.scsys.co.uk
