title: MySQL LIKE + php sprintf
body: <pre><code>$test = sprintf("SELECT * FROM `table` WHERE `text` LIKE '%%s%'", mysql_real_escape_string('test'));
  
  echo $test;
  </code></pre>
  
  <p>output:</p>
  
  <pre><code>SELECT * FROM `table` WHERE `text` LIKE '%s
  </code></pre>
  
  <p>but it should output:</p>
  
  <pre><code>SELECT * FROM `table` WHERE `text` LIKE '%test%'
  </code></pre>