Re[2]: [PHP-DB] Display data begin with "A"
| From: | Victor Foitzik | Date: | Sun, 08 Apr 2001 21:15:47 +0000 |
| Subject: | Re[2]: [PHP-DB] Display data begin with "A" | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8366@lists.php.net to get a copy of this message | ||
Hi,
if you're using MySQL, the simpliest method is using RLIKE
SELECT stuff FROM table WHERE stuff RLIKE '^[0-9]+';
see
http://www.mysql.com/doc/S/t/String_comparison_functions.html
http://www.mysql.com/doc/R/e/Regexp.html
for more info
HTH
Victor
> Okay it's working now..
> How if I want to display all the data begin with NUMBERS. like "1,2,3,...,0"