title: Retrieve Data in Find in set in sql using delimitter
body: <p>I have a column department code which has data such as</p>
  <pre><code>SC
  SS
  MT
  EN
  </code></pre>
  <p>I would like to do a find in set on the column but I am passing data of both department code and description inside the find in set
  my passing data: SC - Science.
  I would like to use - as delimiter and want to use the department code present in the string to be used find in set for the query.</p>
  <p>My SQL code</p>
  <pre><code>SELECT id, dept_code FROM department WHERE dept_code IS NOT NULL AND FIND_IN_SET(dept_code, SUBSTRING_INDEX('SC - Science'), '-', 1) 
  </code></pre>
  <p>but my query does not work.</p>
  <p>Can anyone help me to solve this problem</p>