MySQL & Regexps

MySQL is amazing.  You can do queries with a regular expression as the where clause.  That's incredibly powerful!  Something like:

SELECT EntryText FROM WebDatabase WHERE ExtryText REGEXP "^[Tt]his";

Would get all the entries that started with "this."

Leave A Reply - 1 Reply
Anonymous 2001-07-11 01:53pm - No Email - Logged IP: unknown

SELECT this from webdatabase

All content licensed under the Creative Commons License