How to make a delimited MYSQL query?

Question

MySQL

The question is, the database stores data in this form 1||2||3, you can somehow make a query that would search for matches through separators. For example, I need to select fields where there are values ​​\u200b\u200bof 1 and 2.
PS Don’t talk about another storage method, since data from tv fields is stored in the modX database

Answer 1

https://dev.mysql.com/doc/refman/8.0/en/string-fun...