Good day. A serialized array of the form ["10", "36", "11"] is stored in the base cell, I know that it is better not to do this, but still. How to implement a check for the presence of at least one of the values of this array in a nested sample. For example, if instead of an array there was one value, then the check would look like this "value IN (SELECT)". Tell me, please, the best option.
- the best option is to bring the base to normal form - teran
- INSTR / LOCATE function. Quotation marks with commas do not need to control the framing. - Akina
- Possible duplicate question: mysql search for an integer - Mike
|