select int culomn and compare it with Json array culomn : 
this is row in option culomn in table oc_cart
20,228,27,229

why no result found when value is 228 but result found when value is 20 like below :


select 1 from dual
where  228 in (select option as option from oc_cart)


and result found when i change value to 20 like 

select 1 from dual
where  20in (select option as option from oc_cart)


*option culomn structure type is TEXT





