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

[Rodrigo]

Maybe something like this will do:

my $str =3D 'as23,rt54,yh79';
$schema->resultset('MyTable')
   ->search({ id=3D>[ split /,/ =3D> $str ] });


regards,
rodrigo

On Sat, Aug 11, 2012 at 6:05 PM, Rajeev Prasad <rp.neuli at 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=3D'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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120811/dd5=
e8d76/attachment.htm