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 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 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
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php