Review Groups

Column	From
Name	Begining End Anywhere Equal
Model	Begining End Anywhere Equal

Column	From
Model	Begining End Anywhere Equal
SKU	Begining End Anywhere Equal
UPC	Begining End Anywhere Equal
EAN	Begining End Anywhere Equal
JAN	Begining End Anywhere Equal
ISBN	Begining End Anywhere Equal
MPN	Begining End Anywhere Equal

Match

Full String - xx characters - Match xxx characters either from begining, end, between. Utilize PHP function substr

Substring

Put two values - int $offset, ?int $length = null only.
Checkout
w3schools
OR Copy and paste link Web browser (Google Chrome)
https://www.w3schools.com/php/func_string_substr.asp

PHP WEBSITE
OR Copy and paste link Web browser (Google Chrome)
https://www.php.net/manual/en/function.substr.php

Query	Search String
SELECT p.`product_id` FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON (p.product_id=pd.product_id) WHERE pd.`language_id`='1' AND ( `name` LIKE '%Earrings%' OR `model` LIKE '%Earrings' ) ORDER BY p.product_id ASC LIMIT 0,20	Earrings

Review Groups

Edit Review Groups Form

Conditions