How to find a number using LIKE?

Question

MySQL

Hello everyone, there is a table of approximately the following structure:

All numbers are separated by a comma. How can I extract, for example, records where there is a number 1 in?
But it should be exactly a number and not a figure, i.e. the number 17 does not fit. I try this way, and everything seems to work out, but is it right, won’t some conditions appear later under which the number 17 or, say, 119 or something else will be pulled out?

SELECT * FROM `table` WHERE number = 1 OR number LIKE ',1' OR number LIKE '1,' OR number LIKE ',1,'

Answer 1

FIND_IN_SET() to help you:

SELECT * FROM table_name WHERE FIND_IN_SET(1, numbers) IS NOT NULL

Answer 2

Get it back to normal. Immediately the mountain of crutches will disappear.