List:General Discussion« Previous MessageNext Message »
From:Steve Ruby Date:February 6 2001 6:31pm
Subject:Re: Select a range from 0-9 or A-z
View as plain text  
"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 in the manual

you want

id regexp '^[0-9]'
Thread
Select a range from 0-9 or A-zSeng Ung6 Feb
  • Re: Select a range from 0-9 or A-zSteve Ruby6 Feb
    • Re: Select a range from 0-9 or A-z--==[bMan]==--7 Feb
RE: Select a range from 0-9 or A-zSeng Ung6 Feb
RE: Select a range from 0-9 or A-zChris M. Oson6 Feb
RE: Select a range from 0-9 or A-zThe Tilghman6 Feb