想要使用mysql选择记录，因为它们在表中的状态

good morning guys, i have a problem of selecting all records which are inactive or active in a database, but if i select all estates and all status it returns all the estates and their different status, active or inactive, but if i select all estates and active status it returns all the estates and display that they are all active, same goes with inactive, but when i select all estates and inactive i want it to display all estates that are inactive same goes with the active.good morning guys, i have a problem of selectin