title: how to search for partial words from a database
body: <p>I was creating a searchbox, which should work only by writing partially the value, but i don't know how? <br>
  Here is the code:
  <br></p>
  
  <pre><code>  $sql = "SELECT id, name, someElse FROM My.basic_info WHERE id = '.$searched.' LIKE '%" .$searched."%' ";
  
  
      $result = mysql_query($sql) or die ("Query to POST data from try failed: ".mysql_error());
  
  
      if ($rows=mysql_fetch_assoc($result)) {
  
  
  
  
             echo $rows['id'];
             echo "&lt;br&gt;";
  
             echo $rows['name'];
             echo "&lt;br&gt;";
  
             echo $rows['someElse'];
             echo "&lt;br&gt;";
  
  
        } else {
          echo "What you've searched for cannot be found or isn't the correct checkbox";
          echo "&lt;br&gt;";
        }
  </code></pre>
  
  <p>why doesn't it work? Thanks in advance!!</p>