MySQL选择CURDATE和ORDER [关闭]

Question

I already have a mySQL statement that already selects something from the database and orders it by the closet date but it selects everything and I want it to just select it and order it if 'category' is equal to a certain value say '1'.So my question is what would that stament be would i use 'AND' here is the select stament I already have:

 SELECT `name` 
 FROM `event` 
 WHERE `displaydate` >= CURDATE() 
 ORDER BY `displaydate`

Here is what I think it would be like:

 SELECT `name` 
 FROM `event` 
 WHERE `category` = 1 AND `displaydate` >= CURDATE() 
 ORDER BY `displaydate`

Answer 1

Yes, your statement is correct given that the first statement works and that category is an integer.