Case sensitive and insensitive like in SQLite

by

You can use the UPPER keyword on your case insensitive field then upper-case your like statement. e.g.

SELECT * FROM mytable 
WHERE caseSensitiveField like 'test%' 
AND UPPER(caseInsensitiveField) like 'G2%'

More Related Contents:

  1. How do I rename a column in a SQLite database table?
  2. How do I check in SQLite whether a table exists?
  3. Accessing an SQLite Database in Swift
  4. Import CSV to SQLite
  5. Difference between 2 dates in SQLite
  6. Select random row from a sqlite table
  7. How to get Top 5 records in SqLite?
  8. Sqlite primary key on multiple columns
  9. Can SQLite support multiple users?
  10. Export from sqlite to csv using shell script
  11. SQLite: How do I save the result of a query as a CSV file?
  12. Create table in SQLite only if it doesn’t exist already
  13. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  14. SQLITE_BUSY The database file is locked (database is locked) in wicket
  15. Does it matter what extension is used for SQLite database files?
  16. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  17. Sqlite over a network share [closed]
  18. SQLite table constraint – unique on multiple columns
  19. Is there a boolean literal in SQLite?
  20. SQLite accent-insensitive search
  21. How to have an automatic timestamp in SQLite?
  22. svn cleanup: sqlite: database disk image is malformed
  23. Truncate a SQLite table if it exists?
  24. SELECT INTO statement in sqlite
  25. How to display blob value using x’abc’ binary string literal syntax?
  26. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  27. Integration Testing Entity Framework code first with in-memory database
  28. DbFunctions.TruncateTime LINQ equivalent in EF CORE
  29. How to get the number of rows of the selected result from sqlite3?
  30. How to get the last index of a substring in SQLite?

Leave a Comment