title: MYSQL Search/Wildcards
body: <p>I trying to search a MySQL database using PHP, The search works fine but I'm looking for a little help with wildcards:</p>
  
  <p>The data in the field (Model) I am searching is: "A4" (215 results)</p>
  
  <p>My search string is:</p>
  
  <pre><code>SELECT * FROM `temp_comp`.`mvl` WHERE `Model` LIKE '%A4 Avant%'
  </code></pre>
  
  <p>Is there a way I can still search 'A4 Avant' but this will return any fields that contain 'A4' or 'Avant'</p>
  
  <p>The search term is taken from a csv file so I wanted to try and do this without having to split the two words first and search for 'A4' and/or 'Avant', I have tried the following but get no results:</p>
  
  <pre><code>SELECT * FROM `temp_comp`.`mvl` WHERE `Model` LIKE '%A4%Avant%'
  </code></pre>
  
  <p>As you may have guessed this is not my normal field so any help would be very much appreciated.</p>