title: Wordpress php mysql LIKE query not working
body: <pre><code>$db_item =  $wpdb-&gt;get_results($wpdb-&gt;prepare( "SELECT * FROM wp_wowhead_items WHERE name LIKE %s", "%". "Hello" . "%") );
  </code></pre>
  
  <p>This above one works... But the below one doesn't work!</p>
  
  <pre><code>$text = "Hello";
  $db_item =  $wpdb-&gt;get_results($wpdb-&gt;prepare( "SELECT * FROM wp_wowhead_items WHERE name LIKE %s", "%". $text . "%") );
  </code></pre>
  
  <p>Where am I missing the syntax? I tried almost every combination with quotes, slashes, escapes...</p>