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

Rajeev Prasad rp.neuli at yahoo.com
Sat Aug 11 16:05:02 GMT 2012


here is given string of type:...=A0=A0 "as23,rt54,yh79"
and i have to lookup in a table which has column "id" which has only one fo=
ur letter word. i have to select that row in which the colum 'id' value mat=
ches 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 ha=
ve DBIx statement to use in my perl code. So either suggestion will work fo=
r me.

ty.
Rajeev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120811/b0c=
4fffc/attachment.htm


More information about the DBIx-Class mailing list