title: MySQL status update trigger on delete
body: <p>I want to see your opinion on this issue.</p>
  
  <p>I'm using MySQL database for my projects, and in almost every table, I have a column called <strong>Status</strong> defined (ENUM('active','inactive','deleted')).</p>
  
  <p>I do this for performance reasons, so whenever a row is not needed(deleted), I set it to 'deleted' instead of actually deleting it from the DB. This has proven fairly good.</p>
  
  <p>But, now I always have to write PHP functions in my projects for updating a row from Active to Deleted.</p>
  
  <p>What do you think, how can I solve this using MySQL triggers or using other technique?</p>
  
  <p>Thank you</p>