title: Select * from MyTable where name='%Jack%' in Mysql
body: <p>i want to write a SELECT in MySQL like this SELECT in MS-SQL</p>
  
  <pre><code>SELECT * FROM MyTable WHERE name='%Jack%'
  </code></pre>
  
  <p>and this answer:</p>
  
  <pre><code>+--------+
  | Jack   |
  +--------+
  | Ajack  | 
  +--------+
  | jackA  | 
  +--------+
  | AJackA |
  +--------+
  </code></pre>
  
  <p>in MySql How to do this?</p>