MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: help with syntax
Posted by: Roland Bouman
Date: July 13, 2005 12:39AM

Hi

you could use

SELECT *
FROM table1
WHERE column1 BETWEEN minValue AND maxValue

This should be equivalent to

SELECT *
FROM table1
WHERE column1 >= minValue
AND column1 <= maxValue

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
help with syntax
William Gray
July 12, 2005 07:24AM
Re: help with syntax
EngLee Teh
July 12, 2005 08:12PM
Re: help with syntax
Roland Bouman
July 13, 2005 12:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.