title: Select a particular value of JSON string using MySQL
body: <p>I have a table that looks like this</p>
  
  <pre><code>+------+------------------------------------+
  |  id  |              details               |
  +------+------------------------------------+
  |   1  | {"price":"24.99","currency":"USD"} |
  +------+------------------------------------+
  </code></pre>
  
  <p>Is it possible to, with a single MySQL select statement, obtain the value of price 24.99? </p>