title: MySql SELECT with if statement and LIKE operator
body: <p>I am working on an advertisement site. </p>
  
  <p>I have one table with a column for each day. I need to check in the table which ads is saved as default to update only those ads. </p>
  
  <p>I have tried this, but it not working. </p>
  
  <pre><code>SELECT Monday if (Monday LIKE '%default%'),
  Tuesday if (Tuesday LIKE '%default%')
  FROM `Ad_Relationshp`
  </code></pre>
  
  <p>MySql gives me this error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if (Monday LIKE '%default%') FROM <code>Ad_Relationshp</code> LIMIT 0,' at line 1. I have tried changing the syntax to everything I can think off, but I still get the same error. </p>