title: Select multiple columns using single if condition
body: <p>I have tried the below query but somehow it's not working for me. Can anyone tell me why?</p>
  
  <p>Query :</p>
  
  <pre><code>SELECT column1
       , column2
       , IF(start &lt;="20:00:00" AND end &gt;= "20:00:00")
            THEN (column3,column4,column5)
            ELSE (column6,column7,column8)
         END IF
       , column9
       , column10
  FROM table_1
  WHERE id ="1"
  </code></pre>