title: SQL LIKE operator to find words in stored JSON
body: <p>I have this JSON stored in DB:
  Column name: json</p>
  
  <pre><code>- '{"brand":"1","year":"2008","model":"2","price":"2001212","category":"Category Example"}'
  - '{"brand":"1","year":"2008","model":"2","price":"2001212","category":"Category Example2"}'
  </code></pre>
  
  <p>I want to make a search using Like operator to find all categories with "Category" word:</p>
  
  <p>At this moment Im doing it this way, but only return a complete phrase:</p>
  
  <pre><code>select * from table where json like '%"category":"Category Example"%';
  </code></pre>
  
  <p>How can I build a query that returns all categories with "Category word"?</p>
  
  <p>Updated:</p>
  
  <p>I'm using MySQL
  Thanks</p>