View Full Version : ereg string starts with number
Sicton
05-02-2005, 10:10 PM
Does anyone know the ereg syntax for MySQL to return results that start with a number?
E.g.
ereg('[0-9']*, $string);
but for an SQL statement.
Thanks
Tangerine Dream
05-03-2005, 12:04 PM
Hi, check 3.3.4.7. Pattern Matching (http://dev.mysql.com/doc/mysql/en/pattern-matching.html) for use of REGEXP/RLIKE operator
Sicton
05-16-2005, 11:00 PM
Thanks!
For anyone that wants to know, the expression is:
RLIKE '^[0-9]'
vBulletin® v3.8.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.