Rajeev Prasad search any matching word in given string in table column which has only one word
Aug 11, 2012; 09:05
Rajeev Prasad
search any matching word in given string in table column which has only one word
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...
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
Aug 11
Shawn Green Re: search any matching word in given string in table column which has only one word
Aug 11, 2012; 12:41
Shawn Green
Re: search any matching word in given string in table column which has only one word
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!