title: MySQL wildcard query
body: <p>I'm relatively new with SQL and I ran into a problem/question while doing some practice problems.</p>
  
  <p><a href="https://www.hackerrank.com/challenges/weather-observation-station-8" rel="nofollow">https://www.hackerrank.com/challenges/weather-observation-station-8</a></p>
  
  <p>Here's the query I used with MySQL:</p>
  
  <pre><code>SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '[aeiou]%[aeiou]'
  </code></pre>
  
  <p>I'm confused why this doesn't work. Here's my thinking for the query:</p>
  
  <pre><code>SELECT DISTINCT CITY 
  </code></pre>
  
  <p>^ make sure each city returned isn't repeated</p>
  
  <pre><code>FROM STATION
  </code></pre>
  
  <p>^ from the STATION table</p>
  
  <pre><code>WHERE CITY LIKE '[aeiou]%[aeiou]'
  </code></pre>
  
  <p>^ CITY names that are selected can have the first letter begin with [aeiou], have anything in between, and end with [aeiou].</p>
  
  <p>Any help or advice would be appreciated, thanks!</p>