Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

Re[2]: [PHP-DB] Display data begin with "A" From: Victor Foitzik (vfoitzik <email protected>)
Date: 04/08/01

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" 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>