Re: [sqlite] How to specify regular expression in a query? ( Indexes usage issue)

Bharath Booshan L wrote: There is also a discussion of the REGEXP Function on that page and why your app threw an error when you tried to invoke a REGEXP filter in your query. I have tested that in sqlite3 command-line tool(v3.4.0), but no yield. REGEXP syntax is supported by SQLite, but you

Re: [sqlite] How to specify regular expression in a query? ( Indexes usage issue)

Thanks kjh for your valuable inputs, > If you use US ASCII, there is a collation (COLLATE NOCASE) > that could handle this for you. I am using Unicode characters. > There is also a discussion of the REGEXP Function on that page and why your > app threw an error when you tried to invoke a REGEXP