Balaji Kandasamy Balaji Kandasamy - 3 months ago 52
MySQL Question

Alternative to FIND_IN_SET in SQLite?

In Mysql,

FIND_IN_SET
is used to find value in a set. I have tried
FIND_IN_SET
in SQLite, but it is not an SQL keyword. I have Googled, but I did not get an answer. If anybody knows, please tell me the alternative to
FIND_IN_SET
in SQLite.

Answer

If you need just a true / false value rather than index then you can use LIKE clause:

(',' || column_name || ',') LIKE '%,value,%'