Balaji Kandasamy Balaji Kandasamy - 9 months ago 196
MySQL Question

Alternative to FIND_IN_SET in SQLite?

In Mysql,

is used to find value in a set. I have tried
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
in SQLite.


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

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