title: mysql search without spaces
body: <p>I have a list of names in my database and I have to find the id of the name that I pass in the url.</p>
  
  <p>My problem is that the names I pass in the url will not have a space in them while the saved record will in the database. When I search the database I get no records found.</p>
  
  <p>e.g database record is "My Name" while what I will be passing in the url and searching with is "myname"</p>
  
  <pre><code>if(isset($_GET["name"])) $name = $_GET["name"];
  
  SELECT id
  FROM table
  WHERE name Like '%$name%'
  </code></pre>
  
  <p>Thanks for any help.</p>