title: Mysql search on multiple fields or on merged field
body: <p>I have two tables (simplified):</p>
  
  <pre><code>---------
  page
  ---------
  id
  deleted
  
  ---------
  page_data
  ---------
  id
  id_page
  value_int
  value_float
  value_text
  value_date
  value_serialized
  value_something_else
  </code></pre>
  
  <p>page_data has a lot of different value types. I want to be able to search them all. Is this kind of approach okay?</p>
  
  <pre><code>SELECT * FROM page_data WHERE 
  value_text LIKE '%" . $keyword . "%' 
  OR value_int = ".$keyword."
  OR ....
  OR ....
  </code></pre>
  
  <p>Or would it be better/faster to add a "search" field in page (or page_data) table, and merge all to-be-searched-data into full text? I dont mind slower updating and more management. I want faster search.</p>
  
  <p>Any help would be really appreciated!</p>