title: MySQL query using concat and union not working
body: <p>Hi poeple am trying to get a list of records into one table for a search feature i am doing for a site</p>
  
  <p>the 3 tables are one for page information, 1 for projects and 1 for latest news.</p>
  
  <p>however i am getting an error in my query and i cant see whats wrong with it.</p>
  
  <pre><code>SELECT 'section' AS colTYPE, title_sec AS title,
  CONCAT_WS(' ',contentcol1_sec, contentcol2_sec, contentcol3_sec) AS content, 
  active_sec AS active 
      FROM sections_sec 
      WHERE content LIKE 'fff' OR title LIKE 'fff' AND active = 1) 
      UNION(SELECT 'latest' AS colTYPE, title_lat AS title,
      content_lat AS content, active_lat AS active 
      FROM latest_lat
      WHERE content LIKE 'fff' OR title LIKE 'fff' AND active = 1) 
      UNION(SELECT 'project' AS colTYPE, title_prj AS title, 
      content_prj AS content,     active_prj AS active 
      FROM projects_prj 
      WHERE content LIKE 'fff' OR title LIKE 'fff' AND active = 1)
  </code></pre>
  
  <p>the error i am reciving is:</p>
  
  <pre><code>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 ') 
      UNION(SELECT 'latest' AS colTYPE, title_lat AS title, 
  content_lat AS conten' at line 3
  </code></pre>