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

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-multipli

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: 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 negates any possible

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

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%' or id like '3

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 like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'

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 or A-z hi

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] Subject: Select a rang