title: Having some trouble getting a couple of "wildcard" expressions to work in MySQL
body: <p>Ive been working through the w3schools website and have found it very helpful, however a couple of problems have been giving me trouble.</p>
  <p>[Here is the table for both pieces of syntax]</p>
  <p><img src="https://i.stack.imgur.com/RSo45.png" alt="1" /></p>
  <p>Both of these pieces of syntax appear to be incorrectly returning &quot;empty set&quot;. The syntax is below. Any advice is appreciated!</p>
  <p>Syntax 1</p>
  <pre><code>select * from Student where Surname like '[!acf]%';
  </code></pre>
  <p>Syntax 2</p>
  <pre><code>select * from Student where Name like '[a-f]%';
  </code></pre>