SQLite3 has the REGEXP keyword. That means we can do SQLite queries like
SELECT * FROM table1 WHERE col1 REGEXP '\d+[a-z]+\d*';
.
Unfortunately, the REGEXP keyword references an SQLite user defined function that is not defined by default. That means if we want to use REGEXP in our SQLite...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.