select where mapping id in array implode

Question

+---------+----------+-----------
|   id    |   value  |  map_id  |
+---------+----------+-----------
|    1    |   avcne  |   1,2,3  |
+---------+----------+-----------
|    2    |   fdhsj  |   5,6,7  |
+---------+----------+-----------
|    3    |   kqrno  |   8,9,0  |
+---------+----------+-----------

FROm the table above

SELECT value FROM table_above where map_id = 2

Then the result would be 'avcne'.

SELECT values FROM table_above where map_id = 6

Then the result would be 'fdhsj'.

Is there any better way to do this without using %-% such as

SELECT value FROM table_above where map_id = %2%

Thanks in advance.

Note: this is just for a temporary table.

Bad DB design.. however check for `find_in_set` function of mysql. — Abhik Chakraborty, Aug 09 '15 at 18:46
Yes, I am sure this is not good. but this is for development purpose where data is still temporary. by the way, thanks for the reference. — iyal, Aug 09 '15 at 18:51

score 0 · Accepted Answer · answered Aug 09 '15 at 18:52

0

MySQL's find_in_set is just what you're looking for:

SELECT value FROM table_above WHERE FIND_IN_SET(2, map_id)

answered Aug 09 '15 at 18:52

Mureinik

297,002
52
306
350

select where mapping id in array implode

1 Answers1