title: mysql wildcards % vs %%
body: <p>What is the difference in '%' and '%%', when used in mysql where clause with 'LIKE' ?</p>
  
  <pre><code>select * from `wp_users` u where u.user_nicename like "%lastuser%"
  </code></pre>
  
  <p>VS</p>
  
  <pre><code>select * from `wp_users` u where u.user_nicename like "%%lastuser%%"
  </code></pre>