title: MySQL fulltext search over multiple columns: result confusion
body: <p>I have a search query which performs a fulltext search on the DB.</p>
  
  <pre><code>$sql = "SELECT
  *
  FROM 
  `tbl_auction_listing` AS `al` 
  JOIN 
  `tbl_user` AS `u` ON `al`.`user_id` = `u`.`user_id` 
  LEFT JOIN
  `tbl_gallery_details` AS `gd` ON `al`.`user_id` = `gd`.`user_id`
  LEFT JOIN
  `tbl_self_represented_details` AS `sr` ON `u`.`user_id` = `sr`.`user_id`
  WHERE 
  `al`.`status` = '" . ACTIVE . "'
  AND
  `al`.`start_date` &lt; NOW() 
  AND
  `al`.`end_date` &gt; NOW()
  AND
  MATCH(`al`.`listing_title`,
  `al`.`description`,
  `al`.`provenance`,
  `al`.`title`,
  `al`.`artist_full_name`,
  `al`.`artist_first_name`,
  `al`.`artist_last_name`,
  `sr`.`artist_name`,
  `gd`.`gallery_name`,
  `u`.`username`) AGAINST('$search_query' IN BOOLEAN MODE)";
  </code></pre>
  
  <p>When I search for 'Cardozo, Horacio' or 'cardozo' or 'horacio' I get no results however I know there is an artist with 2 records in the db with artist_full_name = Cardozo, Horacio.</p>
  
  <p>If I remove all MATCH fields and just have <code>al</code>.<code>artist_full_name</code> I get 2 results. If I add in <code>al</code>.<code>description</code> I get 1 result because 'Horacio Cardozo' exists in the description.</p>
  
  <p>Is there a way to have the search return all records if any condition (any search query word) is met in any of the MATCH fields? I tried removing IN BOOLEAN MODE but that produced same results.</p>