How to search for a substring from an array in a database?

Question

Laravel

There is an array(2,3,4)
There is a column in the database that can contain such values ​​as "2", "2.3", "2.4", "2,3,4", etc.
How to write a search condition like whereIn(numbers,array(2,3,4)) only to search as a LIKE %...% construct?

Answer 1

Bitmask: 1,2,4,8,16,32,64,.... sum of digits - will give the bitmask of the desired option.
Let there be an array: array(2,3,4) or array("mom","soap","frame") - it doesn't matter!
It is important that it has a maximum of 3 elements.
Then we make a bit mask for all 3 items:
1+2+4=7 (which is in binary form: 111)
I.e. if there are 7 in the DB field, then we know that all 3 values ​​are selected.
1+0+4=5 (which is in binary form: 101)
I.e. if there is 5 in the DB field, then we know that the first and last value is selected,
and so on.

Answer 2

If not more than 9, then you can use REGEX?
First, of course, you need to do implode('|', $array);
If the numbers are greater than 9, then you need to think.

Answer 3

I understand that "the task is such and we solve it as best we can", but ideally, you need to spread such values ​​​​into a separate table with a many-to-many relationship, because like is not the fastest command, even in the expression like ...%, about like %..% generally silent. And so - solid perversions like `numbers` like %2% and `numbers` like %3% and so on until the end, I am silent about problems with numbers over 9, where you need to define 12 or 1.2.

Answer 4

Convert field to SET type .
In queries use FIND_IN_SET()