title: SHOW TABLES LIKE returns a 1064 syntax error in MySQL
body: <p>I have a simple call to SHOW TABLES and I'm getting a 1064 syntax error.</p>
  
  <pre><code>$query = $this-&gt;db-&gt;query("SHOW TABLES LIKE docx_setting");
  </code></pre>
  
  <p>Returns the following error:</p>
  
  <pre><code>Notice: Error: You have an error in your SQL syntax; check the manual that 
  corresponds to your MySQL server version for the right syntax to use near 
  'docx_setting' at line 1
  
  Error No: 1064
  SHOW TABLES LIKE docx_setting in
  /home/username/dev/web/application/system/database/mysql.php on line 50
  </code></pre>
  
  <p>I've Googled quite a bit and don't see anything wrong with my syntax.  LIKE only supports one pattern so this should be fine.</p>
  
  <p>Any Ideas?</p>
  
  <p>Thanks.</p>
  
  <p>--Vince</p>