MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Ralf Narozny Date:September 18 2002 3:25pm
Subject:Re: mysql LIKE number
View as plain text  

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:rnarozny@stripped, http://www.splendid.de



Thread
mysql LIKE numberadi18 Sep
  • Re: mysql LIKE numberRalf Narozny18 Sep