title: "disable" some MySql records so they are not returned when searching?
body: <p>I have a mysql database which I support using phpMyAdmin.</p>
  
  <p>The website this is for is a classifieds website.</p>
  
  <p>The issue here is that whenever a new classified is posted (and inserted into mysql database), I need to first review it manually.</p>
  
  <p>My question is, is there anyway to tell mysql that "this record is inactive, so don't return it"?</p>
  
  <p>I know of one way offcourse, to add a column named "state" and change it to "active" for all classifieds which I want active. But is there any other method built into mysql which does the same?</p>
  
  <p>In other words, I dont want the record returned when users search the website if the record isn't "reviewed" first by me.</p>
  
  <p>EDIT: </p>
  
  <p>I know of the WHERE clause, that is not my Q here. Is there any other method built into phpMyAdmin?</p>
  
  <p>Thanks</p>