title: Mysql table name with string concate?
body: <p>I want to select all those tables which tables name contain another field name</p>
  
  <p>Like </p>
  
  <pre><code>Show Tables Like  '%' + table.table_name_prefex
  </code></pre>
  
  <p>but this give me an error below.</p>
  
  <blockquote>
  <pre><code>[Err] 1064 - You have an error in your SQL syntax; check the
  </code></pre>
    
    <p>manual that corresponds to your MySQL server version for the right
    syntax to use near '+table.table_name_prfex' at line 1</p>
  </blockquote>