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
