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

Filed under:
|
|

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

Related posts about sql

Related posts about mysql