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
