Forums
This topic is locked
how to get data by multiple values within one fie
Posted 11 Oct 2008 14:54:37
1
has voted
11 Oct 2008 14:54:37 rizwan rizwan posted:
hi all,i am inserting multiple values from a list into one field seprated by commas. eg 23,24,26
but when i m going to search from this field by one of these values by using sql query IN clause,this only checks the first value e.g 23, not the 2nd and 3rd value. and also i donn't want to use any loop, i want to do it just by sql query .have any way to do it.
Thanks to all in advance.