On Tuesday 06 February 2001 13:31, Steve Ruby wrote:
-> "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%
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]
> Subje
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 o
"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 R
-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%'
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%'
thank you
seng
