If the value is comma-separated (and not comma+space separated), you can use FIND_IN_SET
:
SELECT * FROM `table` WHERE FIND_IN_SET('lorem ipsum', `column`);
2
solved mysql: how to select imploded array value [duplicate]
If the value is comma-separated (and not comma+space separated), you can use FIND_IN_SET
:
SELECT * FROM `table` WHERE FIND_IN_SET('lorem ipsum', `column`);
2
solved mysql: how to select imploded array value [duplicate]