Creating a SQL query with a complex LIKE condition?

Question

PHP

There is a cell users with values ​​(1,2,3,4,5,6...). From the user I get a number and I need to select the emails of everyone who has this number in this cell. Help me compose the correct SQL query.

Answer 1

Anything like this?

SELECT *
FROM `table`
WHERE `users` REGEXP '([^0-9]{$user}[^0-9])'

dev.mysql.com/doc/refman/5.6/en/regexp.html
Either like this:

SELECT *
FROM `table`
WHERE `users` LIKE '{$user},%' OR `users` LIKE '%,{$user},%' OR `users` LIKE '%,{$user}'

Answer 2

If I understand the problem correctly:

SELECT email FROM `users` WHERE FIND_IN_SET(1,  usergroups)