title: sql LIKE query only returns exact match, not similar matches
body: <p>I'm working on a <code>$wpdb</code> query to search for items in the media library. The search kind of works, except it only returns exact matches. </p>
  
  <p>I have two images in the library, one called <code>run</code> and the other called <code>running</code>, if I search just <code>run</code>, it only returns the exact match, <code>running</code> isn't returned. Am I missing something here? I thought <code>LIKE</code> returned things that contains those characters?</p>
  
  <p>Here's my query in full, I'm using AJAX to stick it into the page.</p>
  
  <pre><code>include_once($_SERVER['DOCUMENT_ROOT'].'/wp-load.php' );
  
  global $wpdb;
  
  if( isset($_GET['nameLike']) ) {
      $search = $_GET['nameLike'];
  } else {
      $search = '';
  }
  
  $results = $wpdb-&gt;get_results( $wpdb-&gt;prepare("SELECT ID FROM $wpdb-&gt;posts WHERE post_status = 'inherit' AND post_title LIKE %s", $search), ARRAY_A);
  
  foreach ($results as $result) : ?&gt;
  
      &lt;?php $image = wp_get_attachment_image( $result[ID], array(200, 150) ); ?&gt;
  
      &lt;div class="grid-1-4"&gt;&lt;?php echo($image); ?&gt;&lt;/div&gt;
  
  &lt;?php endforeach ?&gt;
  </code></pre>