On Wed, 2008-07-23 at 17:05 +0300, Ali Deniz EREN wrote: > Hi all, > > I have a problem as below: > > A text field -Lets call it 'field1'- contains datas seperated by > commas(,) like this (123,5764,8795,9364,11,232,..... and go on) And so > my lines like these: > > id title filed1 > ------------------------------------------------------------- > 1 title1 123,576412 > 2 title2 123 > 3 title3 576412,8795,123 > 4 title4 123 > 5 title5 576412,1164,12,232 > .. ... ... > .. ... ... > > I am looking for lines which includes the matched value within the > field1 seperated case. For example: > > "SELECT id, title, field1 FROM mesaj WHERE 123 IN (field1)" > > result is. > 1 title1 123,576412 > 2 title2 123 > 4 title4 123 > > But I want it to match with third one. > 3 title3 576412,8795,123 > > Because it have a 123 at the end. But It does not! :( > > Is there another way to do this. LIKE doesn't work because > > "SELECT id, title, field1 FROM mesaj WHERE field1 LIKE 12" returns > many result which is not my intention. > > Thank you. > > > -- > Ali Deniz EREN > [EMAIL PROTECTED] >
How about: WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR field1 LIKE '%,123' OR field1 = '123' ) Note that this could that a long time on large tables. You'd be better off to normalize your tables ;) -- Just my 0.00000002 million dollars worth, Shawn "Where there's duct tape, there's hope." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]