SQLite query, 'LIKE'

sql sqlite sql-like
Lene picture Lene · Sep 27, 2012 · Viewed 49.7k times · Source

I am trying to retrieve information from my database.
I have words like Lim Won Mong and Limited.

If I do my query, SELECT name FROM memberdb WHERE name LIKE '%LIM%', it displays both Lim Won Mong and Limited and I only want data from Lim Won Mong.

How should I rewrite my query?

Answer

jeet picture jeet · Sep 27, 2012

Execute following Query:

select name from memberdb where name like '% LIM %' OR name like "LIM %" OR name like "% LIM" OR name like "LIM"

Related questions

SQLite Like % and _

I can't figure out what the underscore character does in an SQLite like statement. The wildcard character, %, is probably the same as in most other SQL databases. So, what does the _ character do?

Read More
Match only entire words with LIKE?

So 'awesome document' LIKE '%doc%' is true, because doc is a sub-string. But, I want it to be false while 'awesome doc' or 'doc awesome' or 'awesome doc awesome' should be true. How can I do with with …

Read More
Return rows where first character is non-alpha

I'm trying to retrieve all columns that start with any non alpha characters in SQlite but can't seem to get it working. I've currently got this code, but it returns every row: SELECT * FROM TestTable WHERE TestNames NOT LIKE '[…

Read More