Balaji Kandasamy Balaji Kandasamy - 1 year ago 351
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.

Answer Source

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

(',' || column_name || ',') LIKE '%,value,%'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download