title: search in mysql replacing space with null values
body: <p>I need a query to search phone number.  Simple searching is fine, but I have the following condition.</p>
  
  <pre><code>eg : I want to search a number   : 0431248892
  </code></pre>
  
  <p>But the data can be stored in any format in database as users enter it.</p>
  
  <p>Eg :   </p>
  
  <pre><code> 04 3124 8892
               0431248892
           0431 2488 92
  </code></pre>