FIND_IN_SET exists in MySQL but how do I make it in SQLite?
Posted
by Pentium10
on Stack Overflow
See other posts from Stack Overflow
or by Pentium10
Published on 2010-05-26T11:35:18Z
Indexed on
2010/05/26
11:41 UTC
Read the original article
Hit count: 384
In MySQL there exists FIND_IN_SET, that locates a match in a comma separated list.
mysql> SELECT FIND_IN_SET('b','a,b,c,d');
-> 2
How would I be able to do this in SQLite in query?
Please note, that I can't define or add user defined functions, the Android platform doesn't allow it.
© Stack Overflow or respective owner