I have a field inside a table that contains a string made of the country codes:
IT,GB,US,DU,... and I need to check if the customer's country (
GB,IT,..) is inside this string.
I know I can use
CHARINDEX() in SQL to accomplish this result or retrieve the string, convert it in an array and then check with
in_array, but I wonder if there is a way (and if it is better) to do this task during the query.
This is my current code:
Mage::getModel('razorphyn_country/product')->getCollection() ->addFieldToFilter('active', 1); ->addFieldToFilter('productId', $productId);
country is the field that contains the string