-Original Message-
From: Ung, Seng
Sent: Tuesday, February 06, 2001 9:03 AM
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or A-z
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or
"Ung, Seng" wrote:
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id
like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'
see REGEXP
Try:
select whatever from whatever where field like '[0-9]%'
http://www.mysql.com/doc/P/a/Pattern_matching.html
-Original Message-
From: Ung, Seng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:03 AM
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or A-z
hi:
Check out REGEXP in the manual.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: Ung, Seng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:03
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or