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
table column: id
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.