MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:adi Date:September 18 2002 3:17pm
Subject:mysql LIKE number
View as plain text  
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

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