Execute following Query:
select name from memberdb where name like '% LIM %' OR name like "LIM %" OR name like "% LIM" OR name like "LIM"
More Related Contents:
- Match only entire words with LIKE?
- Select first row in each GROUP BY group?
- SQLite – UPSERT *not* INSERT or REPLACE
- How can I list the tables in a SQLite database file that was opened with ATTACH?
- Update table values from another table with the same user name
- SQL Select between dates
- How to pivot in SQLite or i.e. select in wide format a table stored in long format?
- What are valid table names in SQLite?
- FULL OUTER JOIN with SQLite
- Delete column from SQLite table
- sqlite database default time value ‘now’
- How do I insert datetime value into a SQLite database?
- SQLite – ORDER BY RAND()
- Select random row(s) in SQLite
- basic recursive query on sqlite3?
- sqlite alter table add MULTIPLE columns in a single statement
- Drop all tables command
- SQLite auto-increment non-primary key field
- Core Data Performance with Single Parent Entity
- How to create timestamp column with default value ‘now’?
- String concatenation does not work in SQLite
- Unfindable SQLite Syntax Error
- SQLite3 UNIQUE constraint failed error
- Does SQLite3 have prepared statements in Node.js?
- How to select the first N rows of each group?
- SQL Server search using like while ignoring blank spaces
- IF() statement alternative in SQLite
- UPSERT *not* INSERT or REPLACE
- Drop column from SQLite table
- converting int to real in sqlite