MySQL - how to match JSON string in where condition?

Question

I am using MySQL 5.6 , one of my table field contains JSON data. I am getting syntax error when using below query -

SELECT * FROM products WHERE device_id = '1212'and product_id = '54'and option = '"{"229":"20"}"'

field option has value as {"229":"20"} I am getting following error -

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option = '"{"229":"20"}"'
LIMIT 0, 25' at line 1

Please suggest any solution , thanks much!!!

juergen d · Accepted Answer · 2017-02-01 11:00:22Z

5

option is a reserved keyword in MySQL. Use backticks to escape it or choose a different name

... `option` = ...

answered Feb 1, 2017 at 11:00

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL - how to match JSON string in where condition?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related