title: MySQL LEFT JOIN json field with another id from table
body: <p>I have two tables:</p>
  
  <pre><code>Bouquets
  
  +----+------------+
  | id | bouquet    |
  +----+------------+
  |  1 | Package #1 |
  |  2 | Package #2 |
  |  3 | Package #3 |
  |  4 | Package #4 |
  |  5 | Package #5 |
  +----+------------+
  </code></pre>
  
  <p>And</p>
  
  <pre><code>Prices
  +----+----------+-------------------------------------------------------------------+
  | id | reseller | price                                                     
  +----+----------+-------------------------------------------------------------------+
  |  1 |        1 | {"1": "1.11", "2": "0.00", "3": "0.00", "4": "4.44", "5": "5.55"} |
  +----+----------+-------------------------------------------------------------------+
  </code></pre>
  
  <p>I need to get bouquet names that price value is not "0.00"...so i try LEFT JOIN to join bouquets.id ON prices.price but i can't get how?</p>
  
  <p>I need to get this:</p>
  
  <pre><code>+----+------------+
  | id | bouquet    |
  +----+------------+
  |  1 | Package #1 |
  |  4 | Package #4 |
  |  5 | Package #5 |
  +----+------------+
  </code></pre>
  
  <p>Here is my try but i im getting empty result:</p>
  
  <pre><code>SELECT b.id, b.bouquet FROM bouquets b 
  LEFT JOIN prices p ON JSON_CONTAINS(p.price, CAST(b.id as JSON), '$') != "0.00"
  WHERE p.reseller=1;
  </code></pre>