I have this query:
SELECT * FROM `sales_order_item` WHERE `product_options` LIKE '%2010%'
With the last bit being the decoded option id, I need to find two specific option ids to use inside this query.
My problem is that I can't load the options to be decoded.
I've tried the above and got an error stating I'm using a object when it needs to be a string.
I need to be able to get the option ids from the decode json to filter the products ordered in the database with those option values.