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]"
--
Ra
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
---
