get the position of row split by comma

Question

I have a row in my sql table that look like this

I would like to run query with find_in_set like this:

list
------------
1,2,5,33,3,4

SELECT * FROM mytable WHERE FIND_IN_SET( id, list )

and get the position of the result in a new field

Mark Baker · Accepted Answer · 2014-04-01T20:32:38.023

1

FIND_IN_SET() returns the position of the id value in the list, so:

SELECT *,
       FIND_IN_SET( id, list ) as position
  FROM mytable 
 WHERE FIND_IN_SET( id, list )

or

SELECT *,
       FIND_IN_SET( id, list ) as position
  FROM mytable 
 HAVING position > 0

edited Apr 01 '14 at 20:32

answered Apr 01 '14 at 20:21

Mark Baker

http://www.w3resource.com/mysql/string-functions/mysql-find_in_set-function.php The reference for the function. – Richard Christensen Apr 01 '14 at 20:22
wow, thanks a lot. you don't know how much time i tried to figured it out. and it so simple. – oded Apr 02 '14 at 03:24
@oded, maybe if it helped, please accept it as an answer – Guns Apr 09 '14 at 16:12

1 Answers1