对于以JSON字符串编码的结果使用WHERE LIKE

Question

Just like to know if it is possible to do queries on sql table results encoded in JSON?

I have a table value as follows:

column name: keywords 
column result: ["furniture","home furnishings","opening sale","home furnitures","sale and promotions"]

So i'm looking at

$query="SELECT * FROM table WHERE keywords LIKE '%home%' AND keywords LIKE '%furnitures%'";

Is it possible? I tried a query but the results shown do not show accurately.