title: mysql PDO how to bind LIKE
body: <p>In this query </p>
  
  <pre><code>select wrd from tablename WHERE wrd LIKE '$partial%'
  </code></pre>
  
  <p>I'm trying to bind the variable <code>'$partial%'</code> with PDO. Not sure how this works with the <code>%</code> at the end. </p>
  
  <p>Would it be </p>
  
  <pre><code>select wrd from tablename WHERE wrd LIKE ':partial%'
  </code></pre>
  
  <p>where <code>:partial</code> is bound to <code>$partial="somet"</code> </p>
  
  <p>or would it be </p>
  
  <pre><code>select wrd from tablename WHERE wrd LIKE ':partial'
  </code></pre>
  
  <p>where <code>:partial</code> is bound to <code>$partial="somet%"</code></p>
  
  <p>or would it be something entirely different?</p>