title: MySQL JSON_SEARCH - not working with double quotes
body: <p>I have json data as follow in user_details:</p>
  
  <pre><code>"[{"value":"sachin","label":"What's your "first" name?"},{"value":"test@example.com","label":"What's your email?"},{"value":"+911234567890","label":"What's your "phone" number?"},{"value":"xyz","label":"What's your city?"},{"value":"abc","label":"What's your address?"}]"
  </code></pre>
  
  <p>For this I tried with the below query, but it is giving the error. The error happens ONLY when my data contains double quotes ("). How can I make this work?</p>
  
  <pre><code>SELECT CASE WHEN json_search(user_details, 'one', '%name%', null, '$[*].label')
  IS NOT NULL THEN 'name'
  WHEN json_search(user_details, 'one', '%email%', null, '$[*].label')
  IS NOT NULL THEN 'email'
  WHEN json_search(user_details, 'one', '%phone number%', null, '$[*].label') IS NOT NULL THEN 'phone'
  ELSE 'id' END type,
  CASE WHEN json_search(user_details, 'one', '%name%', null, '$[*].label')
  IS NOT NULL THEN
  json_unquote(json_extract(user_details, concat(json_unquote(replace(json_search(user_details, 'one', '%name%', null,
  '$[*].label'),'.label', '')),'.value')))
  WHEN json_search(user_details, 'one', '%email%', null, '$[*].label') IS NOT NULL THEN
  json_unquote(json_extract(user_details, concat(json_unquote(replace(json_search(user_details, 'one', '%email%', null,
  '$[*].label'),'.label', '')),'.value')))
  WHEN json_search(user_details, 'one', '%phone number%', null, '$[*].label') IS NOT NULL THEN
  json_unquote(json_extract(user_details,concat(json_unquote(replace(json_search(user_details, 'one', '%phone%', null,
  '$[*].label'),'.label', '')),'.value')))ELSE user_id END value FROM json_user;
  </code></pre>