SELECT STATEMENT PROBLEM 2

[annasue]

I have this statement for sql:

SELECT * FROM `used_autos` WHERE `mileage` >= 25000 AND <= 50000 ORDER by make

I'm trying to pull all used autos where the mileage is greater than or equal to 25,000 and less than or equal to 50,000. Obviously, I have something wrong in my syntax.

Thanks in advance.
Anna Sue Edwards

 

[towerbase]

Try

SELECT * FROM `used_autos` WHERE `mileage` >= 25000 AND `mileage` <= 50000 ORDER by make

Andrew
Hampshire, UK

 

[TonyGroves]

Or:[tt]
WHERE mileage BETWEEN 25000 AND 50000[/tt]


-----
ALTER world DROP injustice, ADD peace;