title: SQL Concat or LIKE with wildcard?
body: <p>The table includes two columns where one enumerates countries (name) and another capitals (capital). I need to find the country which name is included in its capital. For example country is Mexico and its capital is Mexico City. How is it possible to do using Concat or Like?</p>
  
  <p>I have tried something like</p>
  
  <pre><code>SELECT name,capital FROM world
  WHERE capital LIKE 'world.name&amp;'
  </code></pre>
  
  <p>Also I have tried to go through concat</p>
  
  <pre><code>SELECT name,capital FROM world
  WHERE capital=concat(name,'&amp;')
  </code></pre>
  
  <p>Any idea?</p>
  
  <p>Thanks</p>