Alter MySQL query

How do I alter this query from displaying records > 1500000 to only showing records between 0-1499999?
$sql_query = "SELECT * FROM respop WHERE ListingFirmID in ('RSRE') AND ListPrice > 1500000 ORDER BY ListPrice ASC";

Open in new window

pda4meAsked:
Who is Participating?
 
Roman GhermanSenior Software EngineerCommented:
$sql_query = "SELECT * FROM respop WHERE ListingFirmID in ('RSRE') AND ListPrice between 0 AND 1500000 ORDER BY ListPrice ASC";

Open in new window

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I don't really see a problem to change the > into <  (or better <= , because otherwise you miss those with price = 1500000 ... )
0
 
pda4meAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.