Alternative to FIND_IN_SET in SQLite?

Question

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 1

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

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

Answer 2

we can write query like change into hibernate critearea

my old query

select * FROM game_detail WHERE content_id=176 and FIND_IN_SET(12,group_master_id)

New query

select * 
  FROM game_detail
 WHERE content_id=176
   and (group_master_id LIKE '%12,%'|| group_master_id LIKE '%,12,'|| group_master_id LIKE '%12')