title: how to perform a SELECT on a JSON column in mysql/mariaDB
body: <p>how to apply WHERE clause on JSON column to perform a SELECT query on a table which is having two columns (id Integer, attr JSON). The JSON is nested and in the filter condition there is only one key value pair of json is allowed. This key value pair can be anywhere in the Josn.</p>
  
  <pre><code>+----+-----------------------------------------------------------------
  | id | attr                                                                                          
  |
  +----+-----------------------------------------------------------------
  |  1 | {"id":"0001","type":"donut","name":"Cake","ppu":0.55}                                         
  |
  |  2 | {"id":"0002","type":"donut","name":"Cake","ppu":0.55,"batters":
         {"batter1":100,"batter2":200}} 
  +----+-----------------------------------------------------------------
  </code></pre>