title: how to speed up mysql regex query
body: <p>I want to develope a site for announcing jobs, but because I have a lot of conditions (title,category,tags,city..) I use a MySQL regex statement. However, it's very slow and sometimes results in a 500 internal Server Error</p>
  
  <p>Here is one example :</p>
  
  <pre><code>select * from job 
  where 
  ( LOWER(title) REGEXP 'dév|freelance|free lance| 3eme   grade|inform|design|site|java|vb.net|poo ' 
  or 
  LOWER(description) REGEXP 'dév|freelance|free lance| 3eme grade|inform|design|site|java|vb.net|poo '
   or
   LOWER(tags) REGEXP 'dév|freelance|free lance| 3eme grade|inform|design|site|java|vb.net|poo') 
  and 
  LOWER(ville) REGEXP LOWER('Agadir') 
  and 
  `date`&lt;'2016-01-11' 
  order by `date` desc 
  </code></pre>
  
  <p>Any advice?</p>