CODEWITHSUNDEEP
stringsqlitelocate
SzRaPnEL
SzRaPnEL

Reputation: 171

sqlite string locate

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.

Upvotes: 0

Views: 468

Answers (1)

000
000

Reputation: 27227

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

Upvotes: 1

Related Questions