adi wrote:
>I have a table with column1 text type.
>I want to make a sql query:
>SELECT * from table WHERE column1 LIKE condition,
>to select all record that contain numbers(0..9), and do not select records
>that contain only text.
>Any ideas?
>tx in advance
>
>
column1 REGEXP "[0-9]"
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php