title: MySQL | REGEXP VS Like
body: <p>I have a table CANDIDATE in my db which is running under MySQL 5.5 and I am trying to get rows from table where RAM is contains in firstname, so I can run below two queries, but I would like to know which query we should use for long term with respect to optimization.</p>
  <pre><code>SELECT * FROM CANDIDATE c WHERE firstname REGEXP 'ram';
  SELECT * FROM CANDIDATE c WHERE firstname LIKE'%ram%';
  </code></pre>