title: mysql query to search for address or postcode
body: <p>Hi I am having difficulties writing a perfect sql query that will search for an address or postcode(english). </p>
  
  <p>I stored my postcode as "W1Y TF7". If a user searches using "W1YTF7" (without the space), it does give me any result when it is suppose to return W1Y TF7. </p>
  
  <h2>VENUE</h2>
  
  <ul>
  <li>VenueID</li>
  <li>Name</li>
  <li>Address1</li>
  <li>Address2</li>
  <li>City</li>
  <li>Postcode</li>
  <li>PhoneNumer</li>
  <li>URL</li>
  </ul>
  
  <p>here is my query:</p>
  
  <pre><code>SELECT DISTINCT *
   FROM venue 
  WHERE Name LIKE '%$searchValue%' 
     OR Postcode LIKE '%$searchValue%'
     OR Address2 LIKE '%$searchValue%' 
     OR Postcode LIKE '$searchValue%' 
  </code></pre>