title: Mysql select query using NOT IN / LIKE to retrieve the data
body: <p>I need to fetch the data in mysql using select query as below</p>
  
  <pre><code>Select tid from abc where abc.parameter not like '%DONE%'
  </code></pre>
  
  <p>But data return where parameter column have %DONE% VALUE.</p>
  
  <p>Here I am giving sample data for better understanding</p>
  
  <pre><code>tid    parameter    value
  ***************************
  1       abc         123
  1       def         456
  1       ghi         789
  </code></pre>
  
  <p>I need to retrieve tid where def not in . </p>