PDA

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]'