Tip: mySQL has REGEX built in
Posted: Mon Oct 06, 2003 7:46 am
examples of regex:
will show artist that start with a number
will return 1(boolean):
will return 1(boolean):
the reference:
http://www.mysql.com/doc/en/Regexp.html
will show artist that start with a number
Code: Select all
SELECT artistname FROM artists WHERE artistname REGEXP "^ї0-9]"Code: Select all
SELECT "myword" REGEX "^my.*rd$"Code: Select all
SELECT "that was nice" REGEX "її:<:]]wasїї:>:]]"http://www.mysql.com/doc/en/Regexp.html