title: SQL search with REGEX instead with BETWEEN operator
body: <p>I have MySQL database, and inside table with ads. In one field of table of that database, data is being saved in json format. In that json formatted data, I have key which value contains price (with decimal values). </p>
  
  <p>That field (named for example ad_data), which is saved in database field, contains (json) data like this:</p>
  
  <pre><code>{"single_input_51":"Ad 44 test.","price":"20.00","single_input_4":"ad test title, ad tes title, .","single_input_11":"8.8.2015.","single_input_5":"video test","single_input_6":"https://www.youtube.com/watch?v=nlTPeCs2puw"}
  </code></pre>
  
  <p>I would like to search in that field, so I can find price range that is searched. If for example, user sets in html form he wants to search in ranges from 100.00 do 755.00, SQL should return only rows where that field (which data is saved as json) contains those values that are from 100.00 to 755.00.</p>
  
  <p>So basically, I would want to write something like this with REGEX in SQL for that json formatted contents of that field (numbers here are just examples, I must be able to to this for every starting and closing decimal number, and numbers I will pass programatically): </p>
  
  <pre><code>SELECT id, price FROM ads WHERE price BETWEEN 100.00 AND 755.00
  </code></pre>
  
  <p>What would be SQL command for that search via REGEX?</p>