Re: Re: select a range MySQL

> > Il mer, 2003-01-15 alle 17:48, Paul DuBois ha scritto: > > > > > Hard to say. Even if that syntax was legal, the logic doesn't > > make sense. What does it mean to be "greater than" or "less than" > > a pattern that has a "match-anything" wildcard at the beginning. > > That completely neg

Re: select a range

At 14:11 +0100 1/15/03, bruno peracchio wrote: Hi I'm newbie I have to find from xvalue to yvalue; I have written: $query="SELECT * FROM inner-multipli WHERE cod_int LIKE =>'%$cod_int1%' AND cod_int LIKE <='%$cod_int2'=; This not work; how can I do? Hard to say. Even if that syntax was legal,

Re: select a range

if your using numbers , which i guess you are, you do not need to use LIKE. $query="SELECT * FROM inner-multipli WHERE cod_in >=$cod_int1 AND cod_int <=$cod_int2"; bruno peracchio wrote: Hi I'm newbie I have to find from xvalue to yvalue; I have written: $query="SELECT * FROM inner-multipl

select a range

Hi I'm newbie I have to find from xvalue to yvalue; I have written: $query="SELECT * FROM inner-multipli WHERE cod_int LIKE =>'%$cod_int1%' AND cod_int LIKE <='%$cod_int2'=; This not work; how can I do? Thanks in advance bruper

Re: Select a range from 0-9 or A-z

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%

RE: Select a range from 0-9 or A-z

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

RE: Select a range from 0-9 or A-z

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

Re: Select a range from 0-9 or A-z

"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

RE: Select a range from 0-9 or A-z

-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%'

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%&