title: How to list all the instances where the names in the fields are 4 letters only?
body: <p>List all names of employees who have 4 letters only in their names.</p>
  
  <p>Im using livesql btw since i didnt know how to set up a server after downloading mysql. im using the emp table provided at lviesql.com
  Im currently preparing for a SQL test and came across this question while revising. The question is "List all names of employees who have 4 letters". I dont know how to apply the LIKE "%" thingy to this. I tried "____%" but i got an error message in return. How do I need to write my query?</p>
  
  <pre><code>select *
  from emp
  where ENAME LIKE "____%"
  </code></pre>
  
  <p>The error message is ORA-00904: "____%": invalid identifier.</p>