sqlite string locate

Question

What is the syntax in SQLite to get all values which contains given string?

I tried: SELECT columnName FROM tableName WHERE LOCATE(string,columnName)!=0; but it didn't work.

score 1 · Accepted Answer · answered Mar 29 '13 at 16:59

1

SELECT columnName FROM tableName WHERE columnname LIKE '%string%'

answered Mar 29 '13 at 16:59

000

1 Answers1