title: Mysql query error #1241 - Operand should contain 1 column(s)
body: <p>i'm trying to debug a php mysql script and i found the error in the query below</p>
  
  <pre><code> SELECT `profile`.*,`extend`.* ,`online`.`hash` AS `online` FROM `skadate_profile` AS `profile` LEFT JOIN `skadate_profile_extended` AS `extend` USING( `profile_id` ) LEFT JOIN `skadate_profile_online` AS `online` USING( `profile_id` ) WHERE `profile`.`profile_id`!= 116 AND 1 AND `profile`.`profile_id` NOT IN ( SELECT `blocked_id` FROM `skadate_profile_block_list` WHERE `profile_id` =116 ) AND ( 16&amp;IF( ISNULL(`match_religion`) OR `match_religion`=0, 0xffffffffffffffff, `match_religion` ) AND 16&amp;IF( ISNULL(`religion`) OR `religion`=0, 0xffffffffffffffff, `religion` ) ) AND FIND_IN_SET('448','3,475,342,448') AND ( 16384&amp;IF( ISNULL(`match_language_`) OR `match_language_`=0, 0xffffffffffffffff, `match_language_` ) AND 16384&amp;IF( ISNULL(`language`) OR `language`=0, 0xffffffffffffffff, `language` ) ) AND ( 0xffffffffffffffff&amp;IF( ISNULL(`sex`) OR `sex`=0, 0xffffffffffffffff, `sex` ) AND 1&amp;IF( ISNULL(`match_sex`) OR `match_sex`=0, 0xffffffffffffffff, `match_sex` ) ) AND ( 1&amp;IF( ISNULL(`match_resident_status`) OR `match_resident_status`=0, 0xffffffffffffffff, `match_resident_status` ) AND 7&amp;IF( ISNULL(`resident_status`) OR `resident_status`=0, 0xffffffffffffffff, `resident_status` ) ) AND ( 8&amp;IF( ISNULL(`match_occupation`) OR `match_occupation`=0, 0xffffffffffffffff, `match_occupation` ) AND 4294971400&amp;IF( ISNULL(`occupation`) OR `occupation`=0, 0xffffffffffffffff, `occupation` ) ) AND ( 91&amp;IF( ISNULL(`match_education`) OR `match_education`=0, 0xffffffffffffffff, `match_education` ) AND 1,28,92&amp;IF( ISNULL(`education`) OR `education`=0, 0xffffffffffffffff, `education` ) ) AND ( `profile`.`status`='active' ) AND `profile`.`profile_id`!= 116 AND `profile`.`sex` != 1 LIMIT 0, 15
  </code></pre>
  
  <p>the query on being run in phpmyadmin gives the error 1241 Operand should contain 1 column(s) in the last part, i.e</p>
  
  <pre><code>IF( ISNULL(`education`) OR `education`=0, 0xffffffffffffffff, `education` )
  </code></pre>
  
  <p>any ideA how can this be fixed.. any help is highly appreciated..</p>