title: How to search a field with a JSON value in MySQL?
body: <p>I have a MySQL column containing fields with data looking like this:</p>
  
  <pre><code>["I don't read books anymore","books \/ novels"]
  </code></pre>
  
  <p>I would like to retrieve all fields with 'books / novels'. How can I do so? I tried:</p>
  
  <pre><code>SELECT * FROM `table` where data_field like '%books \/ novels%'
  </code></pre>
  
  <p>but that returns zero results. Why? How are JSON fields supposed to be searched?</p>