SQL Query to SELECT strings which are either words
<p>I am working on the following query:Find the country where the capital is the country plus "City". Hopefully, you can infer what I mean:</p>

<p>The following query will solve such:</p>

<pre><code>SELECT world.name
  FROM world
WHERE world.capital LIKE CONCAT(world.name, " City")
</code></pre>

<p>Now, say that I also wanted to match for another word, Town. We could do something like this:</p>

<pre><code>SELECT world.name
  FROM world
WHERE world.capital LIKE CONCAT(world.name, " City") OR world.capital LIKE CONCAT(world.name, " Town")
</code></pre>

<p>Can I condense the above statement to only one LIKE clause? Say something like this?</p>

<pre><code>SELECT world.name
 FROM world
WHERE world.capital LIKE CONCAT(world.name, " [City,Town]")
</code></pre>

<p>I just want a more terse SQL statement</p>