regex - How to use regexp in sqlite

Question

Please prompt, how used REGEXP in SQLite?

Realization:

SELECT field FROM table WHERE field REGEXP '123'

It is not working. Error: no such function: REGEXP

Answer 1

Currently am working on sqlite3+php for my web application in Ubuntu 12.04. I was also faced the same issue then after research i had found that we need to install one pcre package for sqlite3. Here we go how to

1. apt-get install sqlite3-pcre
2. Then go to sqlite3 command line sqlite3 test.db
3. run the command .load /usr/lib/sqlite3/pcre.so
4. test : SELECT url FROM table_name where url REGEXP '^google.*';

After following those 3 steps its working fine for me. If am wrong regarding this please correct me. I hope it will help you

Thanks