title: Search bar should ignore “-”, Caps and spaces (132D123 and 132 d 123 should return true) ? php
body: <p>Currently when i search the registration number 131-D-12345 I have to type the hyphens to get the results, but I wish to ignore  “-”, caps and spaces (so for instance &quot;132D123&quot; and &quot;132 d 123&quot; should return true).</p>
  <p>How can I do that in PHP?</p>
  <pre><code>&lt;?php
          require('/home/s3022041/sqlC/dbConnect.php');
          if(isset($_POST['searchById']))
          {
              $search = mysqli_real_escape_string($connection, $_POST['get_id']);
          $id = $_POST['get_id'];
          $query = &quot;SELECT * FROM cars WHERE Registration_Number = '$id' &quot;;
       $query_run = mysqli_query($connection, $query);
      ?&gt;
  
  </code></pre>