Hello, I understand from the SQLite documentation that no regular expression function is defined by default in SQLite. I have seen scripts that define a regular expression function in Python or PHP, and use that in their SQLite query as the REGEXP function. However, I would like to perform regular expression queries interactively, i.e. from the sqlite> prompt. What is the easiest way to do this?
Although I much prefer SQLite to MySQL in terms of simplicity, this is one feature I do miss since migrating my database from MySQL to SQLite. Thanks, Neil
