Webmaster Forum - View Single Post

painperdu · 05-03-2005, 09:41 AM

Try this:

Code:

SELECT * FROM table WHERE column REGEXP '^[[:digit:]]';

05-03-2005, 09:41 AM	#2 (permalink)
painperdu Inactive Join Date: 04-29-04 Location: Louisiana Posts: 32 iTrader: 0 / 0% Latest Blog: None	Try this: Code: SELECT * FROM table WHERE column REGEXP '^[[:digit:]]'; From http://dev.mysql.com/doc/mysql/en/pattern-matching.html