title: How to use the 'like' operator in SQL?
body: <p>I want to select from <code>C_Table</code> where <code>Name='John'</code> and use the <code>like</code> operator. For example,</p>
  
  <pre><code>select Name from C_Table where Name='John' AND where Details like %Boy%
  </code></pre>
  
  <p>How do I do this?</p>
  
  <pre><code>(Table name is C_Table)
  -----------------------------------------------
  Name   |  P_No  |  C_No   |  Details          |
  -----------------------------------------------
  John   |  001   |  001    |  Good Boy         |
  John   |  002   |  002    |  Naughty Boy      |
  John   |  003   |  003    |  Very Bad Boy     |
  Mary   |  004   |  004    |  Beautiful Girl   |
  Mary   |  005   |  005    |  Pretty Girl      |
  Mary   |  006   |  005    |  Gorgeous         |
  -----------------------------------------------
  </code></pre>