Are You Using Regular Expressions Within SQL?
By trent on 27 Dec in Programming
Many may not know(I just recently learned) about using regular expressions within SQL statements. Instead of using substring functions and such, we can create a clean little regular expression(Oracle):
SELECT zip FROM zipcode WHERE REGEXP_LIKE(zip, '[^[:digit:]]')
Keep in mind however that just like SQL syntax varies for each database(MySQL, Oracle, Postgres, etc.) so does the regular expression techniques. The following are a couple links to help you get started.
Unfortunately a little research shows SQLite does not natively support this. It sounds like dangerous waters to begin with, but if you know you won’t be switching database engines often the benefits can be rewarding!