MySQL Forums
Forum List  »  MySQL Query Browser

Help : WHERE FIND_IN_SET usage : list is a column
Posted by: Fabrice QUESTEL
Date: February 28, 2013 09:30AM

Hello all,

I need help resolve my query


My table is 'table1' (id:INT, ref:varchar, ids:text)
---------------------
|id | ref | ids |
---------------------
|1 | a | 2, 3, 4 |
|2 | b | 2, 5, 8 |
---------------------

SELECT id, ref FROM table1 WHERE FIND_IN_SET('5',ids);

I need this result :

-----------
|2 | b |
-----------

But the result of my query is 0 result.

Thanks for your help.

FQ.



Edited 1 time(s). Last edit at 02/28/2013 10:08AM by Fabrice QUESTEL.

Options: ReplyQuote


Subject
Written By
Posted
Help : WHERE FIND_IN_SET usage : list is a column
February 28, 2013 09:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.