title: How do I return true or false if multiple columns equal a certain value in MySQL query?
body: <p>I have a single DB table (MySQL) which I am running a simple SELECT on. In this table I have 3 fields which contain 3 possible values each. In each case the values are identical ('none','online','physical'). I want to return in my result a true or false value for an alias if any one of these fields are not set to 'none'.</p>
  
  <p>I can easily evaluate this in PHP after I've returned my result set but in order to sort my results easily I would rather generate the true/false in the SELECT if possible. So at present a result row might look like this:</p>
  
  <pre><code>id: 1 
  trial_type_1: none
  trial_type_2: online
  trial_type_3: none
  </code></pre>
  
  <p>In this case I want the query to return:</p>
  
  <pre><code>id: 1
  trial: True
  </code></pre>
  
  <p>If all the trial_type fields were set to none then it would return a trial value of False. Any ideas greatly appreciated since I really have no idea where to start or even what to search for online! :)</p>