WHERE语句中的mySQL多重AND比较

Question

I have the following mySQL statement which is incorrect.

SELECT id, location__, image__, bedrooms, bathrooms, price__ 
FROM myTable 
WHERE LOWER(location__) REGEXP '.london.' 
AND (bedrooms >=2) 
AND (bathrooms == true) 
ORDER BY price__  DESC 
LIMIT 0,20;

How do I format a SQL query that works in PHP so that I can compare bedrooms > 2 AND bathrooms > 2 AND ensuites = 1 (i.e. true)... etc

Answer 1

You just need to add condition as you like with AND to fulfill your requirement here.

SELECT id, location__, image__, bedrooms, bathrooms, price__ 
FROM myTable 
WHERE LOWER(location__) REGEXP '.london.' 
AND bedrooms >=2
AND bathrooms >=2 and ensuites = 1
ORDER BY price__  DESC 
LIMIT 0,20;