MySQL SELECT WHERE IN query issue

Question

I have works table, with columns id, employer_key, task_key, etc. The task_key column contains task keys such as 122,142, or just one key 124, or more.

My problem is when I do the query:

"SELECT * FROM works WHERE 122 IN(task_key)";

The query works only if the 122 is the first number listed, but if I search for 142, the second number listed, I don't get any result. Does anyone know why?

Jakub Kania · Accepted Answer · 2015-10-09 16:58:14Z

1

You probably should change your schema but to do what you want you can use FIND_IN_SET()

SELECT * 
FROM works 
WHERE FIND_IN_SET('122',task_key) > 0

answered Oct 9, 2015 at 16:58

Jakub Kania

16.6k2 gold badges44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL SELECT WHERE IN query issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related