title: MYSQL — Number formatting issue
body: <p>I'm working on a gig right now where the client wants the user to be able to search for a product by product code.</p>
  
  <p>A product code is formatted like so: 123.4567.89</p>
  
  <p>So, the search box should return that product whether the user enters the number with the periods, without the periods, or with spaces.</p>
  
  <p>So, all of the following should return the product: 123.4567.89, 123456789, 123 4567 89.</p>
  
  <p>My current query looks like so:</p>
  
  <pre><code>SELECT      *
  FROM        products
  WHERE       product_code LIKE '%$search_code%'"
  </code></pre>
  
  <p>I'm at a loss as to how I would revise that to include all the different possibilities of how a user would input these numbers.</p>
  
  <p>Thanks in advance for any help.</p>