UPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"guarancee ")
WHERE
(
`name` LIKE "100#_%" escape "#"
OR `name` LIKE "%#_100#_%" escape "#" OR
`name` LIKE "% 100 %" OR
`name` LIKE "%100 %" OR
`name` LIKE "%#_100" escape "#"
OR `name` LIKE "%-100#_%" escape "#"
OR `name` LIKE "100-" OR
`name` LIKE "100.%" OR
`name` LIKE "100-%" OR
`name` LIKE "%-100-%"
)
AND `key_words` NOT LIKE "%guarancee%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"sport ")
WHERE
(
`name` LIKE "ball#_%" escape "#"
OR `name` LIKE "%#_ball#_%" escape "#" OR
`name` LIKE "% ball %" OR
`name` LIKE "%ball %" OR
`name` LIKE "%#_ball" escape "#"
OR `name` LIKE "%-ball#_%" escape "#"
OR `name` LIKE "ball-" OR
`name` LIKE "ball.%" OR
`name` LIKE "ball-%" OR
`name` LIKE "%-ball-%"
)
AND `key_words` NOT LIKE "%sport%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"nature ")
WHERE
(
`name` LIKE "bio#_%" escape "#"
OR `name` LIKE "%#_bio#_%" escape "#" OR
`name` LIKE "% bio %" OR
`name` LIKE "%bio %" OR
`name` LIKE "%#_bio" escape "#"
OR `name` LIKE "%-bio#_%" escape "#"
OR `name` LIKE "bio-" OR
`name` LIKE "bio.%" OR
`name` LIKE "bio-%" OR
`name` LIKE "%-bio-%"
)
AND `key_words` NOT LIKE "%nature%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"product ")
WHERE
(
`name` LIKE "box#_%" escape "#"
OR `name` LIKE "%#_box#_%" escape "#" OR
`name` LIKE "% box %" OR
`name` LIKE "%box %" OR
`name` LIKE "%#_box" escape "#"
OR `name` LIKE "%-box#_%" escape "#"
OR `name` LIKE "box-" OR
`name` LIKE "box.%" OR
`name` LIKE "box-%" OR
`name` LIKE "%-box-%"
)
AND `key_words` NOT LIKE "%product%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"transport ")
WHERE
(
`name` LIKE "car#_%" escape "#"
OR `name` LIKE "%#_car#_%" escape "#" OR
`name` LIKE "% car %" OR
`name` LIKE "%car %" OR
`name` LIKE "%#_car" escape "#"
OR `name` LIKE "%-car#_%" escape "#"
OR `name` LIKE "car-" OR
`name` LIKE "car.%" OR
`name` LIKE "car-%" OR
`name` LIKE "%-car-%"
)
AND `key_words` NOT LIKE "%transport%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"refund ")
WHERE
(
`name` LIKE "cashback#_%" escape "#"
OR `name` LIKE "%#_cashback#_%" escape "#" OR
`name` LIKE "% cashback %" OR
`name` LIKE "%cashback %" OR
`name` LIKE "%#_cashback" escape "#"
OR `name` LIKE "%-cashback#_%" escape "#"
OR `name` LIKE "cashback-" OR
`name` LIKE "cashback.%" OR
`name` LIKE "cashback-%" OR
`name` LIKE "%-cashback-%"
)
AND `key_words` NOT LIKE "%refund%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"help ")
WHERE
(
`name` LIKE "customer#_%" escape "#"
OR `name` LIKE "%#_customer#_%" escape "#" OR
`name` LIKE "% customer %" OR
`name` LIKE "%customer %" OR
`name` LIKE "%#_customer" escape "#"
OR `name` LIKE "%-customer#_%" escape "#"
OR `name` LIKE "customer-" OR
`name` LIKE "customer.%" OR
`name` LIKE "customer-%" OR
`name` LIKE "%-customer-%"
)
AND `key_words` NOT LIKE "%help%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"premium ")
WHERE
(
`name` LIKE "diamond#_%" escape "#"
OR `name` LIKE "%#_diamond#_%" escape "#" OR
`name` LIKE "% diamond %" OR
`name` LIKE "%diamond %" OR
`name` LIKE "%#_diamond" escape "#"
OR `name` LIKE "%-diamond#_%" escape "#"
OR `name` LIKE "diamond-" OR
`name` LIKE "diamond.%" OR
`name` LIKE "diamond-%" OR
`name` LIKE "%-diamond-%"
)
AND `key_words` NOT LIKE "%premium%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"money ")
WHERE
(
`name` LIKE "dollar#_%" escape "#"
OR `name` LIKE "%#_dollar#_%" escape "#" OR
`name` LIKE "% dollar %" OR
`name` LIKE "%dollar %" OR
`name` LIKE "%#_dollar" escape "#"
OR `name` LIKE "%-dollar#_%" escape "#"
OR `name` LIKE "dollar-" OR
`name` LIKE "dollar.%" OR
`name` LIKE "dollar-%" OR
`name` LIKE "%-dollar-%"
)
AND `key_words` NOT LIKE "%money%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"liquid ")
WHERE
(
`name` LIKE "drop#_%" escape "#"
OR `name` LIKE "%#_drop#_%" escape "#" OR
`name` LIKE "% drop %" OR
`name` LIKE "%drop %" OR
`name` LIKE "%#_drop" escape "#"
OR `name` LIKE "%-drop#_%" escape "#"
OR `name` LIKE "drop-" OR
`name` LIKE "drop.%" OR
`name` LIKE "drop-%" OR
`name` LIKE "%-drop-%"
)
AND `key_words` NOT LIKE "%liquid%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"nature ")
WHERE
(
`name` LIKE "eco#_%" escape "#"
OR `name` LIKE "%#_eco#_%" escape "#" OR
`name` LIKE "% eco %" OR
`name` LIKE "%eco %" OR
`name` LIKE "%#_eco" escape "#"
OR `name` LIKE "%-eco#_%" escape "#"
OR `name` LIKE "eco-" OR
`name` LIKE "eco.%" OR
`name` LIKE "eco-%" OR
`name` LIKE "%-eco-%"
)
AND `key_words` NOT LIKE "%nature%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"quick ")
WHERE
(
`name` LIKE "fast#_%" escape "#"
OR `name` LIKE "%#_fast#_%" escape "#" OR
`name` LIKE "% fast %" OR
`name` LIKE "%fast %" OR
`name` LIKE "%#_fast" escape "#"
OR `name` LIKE "%-fast#_%" escape "#"
OR `name` LIKE "fast-" OR
`name` LIKE "fast.%" OR
`name` LIKE "fast-%" OR
`name` LIKE "%-fast-%"
)
AND `key_words` NOT LIKE "%quick%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"handmade ")
WHERE
(
`name` LIKE "hand-made#_%" escape "#"
OR `name` LIKE "%#_hand-made#_%" escape "#" OR
`name` LIKE "% hand-made %" OR
`name` LIKE "%hand-made %" OR
`name` LIKE "%#_hand-made" escape "#"
OR `name` LIKE "%-hand-made#_%" escape "#"
OR `name` LIKE "hand-made-" OR
`name` LIKE "hand-made.%" OR
`name` LIKE "hand-made-%" OR
`name` LIKE "%-hand-made-%"
)
AND `key_words` NOT LIKE "%handmade%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"hand-made ")
WHERE
(
`name` LIKE "handmade#_%" escape "#"
OR `name` LIKE "%#_handmade#_%" escape "#" OR
`name` LIKE "% handmade %" OR
`name` LIKE "%handmade %" OR
`name` LIKE "%#_handmade" escape "#"
OR `name` LIKE "%-handmade#_%" escape "#"
OR `name` LIKE "handmade-" OR
`name` LIKE "handmade.%" OR
`name` LIKE "handmade-%" OR
`name` LIKE "%-handmade-%"
)
AND `key_words` NOT LIKE "%hand-made%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"heart ")
WHERE
(
`name` LIKE "heart#_%" escape "#"
OR `name` LIKE "%#_heart#_%" escape "#" OR
`name` LIKE "% heart %" OR
`name` LIKE "%heart %" OR
`name` LIKE "%#_heart" escape "#"
OR `name` LIKE "%-heart#_%" escape "#"
OR `name` LIKE "heart-" OR
`name` LIKE "heart.%" OR
`name` LIKE "heart-%" OR
`name` LIKE "%-heart-%"
)
AND `key_words` NOT LIKE "%heart%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"support ")
WHERE
(
`name` LIKE "help#_%" escape "#"
OR `name` LIKE "%#_help#_%" escape "#" OR
`name` LIKE "% help %" OR
`name` LIKE "%help %" OR
`name` LIKE "%#_help" escape "#"
OR `name` LIKE "%-help#_%" escape "#"
OR `name` LIKE "help-" OR
`name` LIKE "help.%" OR
`name` LIKE "help-%" OR
`name` LIKE "%-help-%"
)
AND `key_words` NOT LIKE "%support%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"heart ")
WHERE
(
`name` LIKE "herz#_%" escape "#"
OR `name` LIKE "%#_herz#_%" escape "#" OR
`name` LIKE "% herz %" OR
`name` LIKE "%herz %" OR
`name` LIKE "%#_herz" escape "#"
OR `name` LIKE "%-herz#_%" escape "#"
OR `name` LIKE "herz-" OR
`name` LIKE "herz.%" OR
`name` LIKE "herz-%" OR
`name` LIKE "%-herz-%"
)
AND `key_words` NOT LIKE "%heart%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"secure ")
WHERE
(
`name` LIKE "lock#_%" escape "#"
OR `name` LIKE "%#_lock#_%" escape "#" OR
`name` LIKE "% lock %" OR
`name` LIKE "%lock %" OR
`name` LIKE "%#_lock" escape "#"
OR `name` LIKE "%-lock#_%" escape "#"
OR `name` LIKE "lock-" OR
`name` LIKE "lock.%" OR
`name` LIKE "lock-%" OR
`name` LIKE "%-lock-%"
)
AND `key_words` NOT LIKE "%secure%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"premium ")
WHERE
(
`name` LIKE "medal#_%" escape "#"
OR `name` LIKE "%#_medal#_%" escape "#" OR
`name` LIKE "% medal %" OR
`name` LIKE "%medal %" OR
`name` LIKE "%#_medal" escape "#"
OR `name` LIKE "%-medal#_%" escape "#"
OR `name` LIKE "medal-" OR
`name` LIKE "medal.%" OR
`name` LIKE "medal-%" OR
`name` LIKE "%-medal-%"
)
AND `key_words` NOT LIKE "%premium%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"payment ")
WHERE
(
`name` LIKE "money#_%" escape "#"
OR `name` LIKE "%#_money#_%" escape "#" OR
`name` LIKE "% money %" OR
`name` LIKE "%money %" OR
`name` LIKE "%#_money" escape "#"
OR `name` LIKE "%-money#_%" escape "#"
OR `name` LIKE "money-" OR
`name` LIKE "money.%" OR
`name` LIKE "money-%" OR
`name` LIKE "%-money-%"
)
AND `key_words` NOT LIKE "%payment%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"refund ")
WHERE
(
`name` LIKE "money back#_%" escape "#"
OR `name` LIKE "%#_money back#_%" escape "#" OR
`name` LIKE "% money back %" OR
`name` LIKE "%money back %" OR
`name` LIKE "%#_money back" escape "#"
OR `name` LIKE "%-money back#_%" escape "#"
OR `name` LIKE "money back-" OR
`name` LIKE "money back.%" OR
`name` LIKE "money back-%" OR
`name` LIKE "%-money back-%"
)
AND `key_words` NOT LIKE "%refund%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"fitness ")
WHERE
(
`name` LIKE "muscule#_%" escape "#"
OR `name` LIKE "%#_muscule#_%" escape "#" OR
`name` LIKE "% muscule %" OR
`name` LIKE "%muscule %" OR
`name` LIKE "%#_muscule" escape "#"
OR `name` LIKE "%-muscule#_%" escape "#"
OR `name` LIKE "muscule-" OR
`name` LIKE "muscule.%" OR
`name` LIKE "muscule-%" OR
`name` LIKE "%-muscule-%"
)
AND `key_words` NOT LIKE "%fitness%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"eco ")
WHERE
(
`name` LIKE "nature#_%" escape "#"
OR `name` LIKE "%#_nature#_%" escape "#" OR
`name` LIKE "% nature %" OR
`name` LIKE "%nature %" OR
`name` LIKE "%#_nature" escape "#"
OR `name` LIKE "%-nature#_%" escape "#"
OR `name` LIKE "nature-" OR
`name` LIKE "nature.%" OR
`name` LIKE "nature-%" OR
`name` LIKE "%-nature-%"
)
AND `key_words` NOT LIKE "%eco%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"organic ")
WHERE
(
`name` LIKE "nature#_%" escape "#"
OR `name` LIKE "%#_nature#_%" escape "#" OR
`name` LIKE "% nature %" OR
`name` LIKE "%nature %" OR
`name` LIKE "%#_nature" escape "#"
OR `name` LIKE "%-nature#_%" escape "#"
OR `name` LIKE "nature-" OR
`name` LIKE "nature.%" OR
`name` LIKE "nature-%" OR
`name` LIKE "%-nature-%"
)
AND `key_words` NOT LIKE "%organic%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"nature ")
WHERE
(
`name` LIKE "organic#_%" escape "#"
OR `name` LIKE "%#_organic#_%" escape "#" OR
`name` LIKE "% organic %" OR
`name` LIKE "%organic %" OR
`name` LIKE "%#_organic" escape "#"
OR `name` LIKE "%-organic#_%" escape "#"
OR `name` LIKE "organic-" OR
`name` LIKE "organic.%" OR
`name` LIKE "organic-%" OR
`name` LIKE "%-organic-%"
)
AND `key_words` NOT LIKE "%nature%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"vip ")
WHERE
(
`name` LIKE "premium#_%" escape "#"
OR `name` LIKE "%#_premium#_%" escape "#" OR
`name` LIKE "% premium %" OR
`name` LIKE "%premium %" OR
`name` LIKE "%#_premium" escape "#"
OR `name` LIKE "%-premium#_%" escape "#"
OR `name` LIKE "premium-" OR
`name` LIKE "premium.%" OR
`name` LIKE "premium-%" OR
`name` LIKE "%-premium-%"
)
AND `key_words` NOT LIKE "%vip%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"premium ")
WHERE
(
`name` LIKE "quality#_%" escape "#"
OR `name` LIKE "%#_quality#_%" escape "#" OR
`name` LIKE "% quality %" OR
`name` LIKE "%quality %" OR
`name` LIKE "%#_quality" escape "#"
OR `name` LIKE "%-quality#_%" escape "#"
OR `name` LIKE "quality-" OR
`name` LIKE "quality.%" OR
`name` LIKE "quality-%" OR
`name` LIKE "%-quality-%"
)
AND `key_words` NOT LIKE "%premium%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"fast ")
WHERE
(
`name` LIKE "quick#_%" escape "#"
OR `name` LIKE "%#_quick#_%" escape "#" OR
`name` LIKE "% quick %" OR
`name` LIKE "%quick %" OR
`name` LIKE "%#_quick" escape "#"
OR `name` LIKE "%-quick#_%" escape "#"
OR `name` LIKE "quick-" OR
`name` LIKE "quick.%" OR
`name` LIKE "quick-%" OR
`name` LIKE "%-quick-%"
)
AND `key_words` NOT LIKE "%fast%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"satisfaction ")
WHERE
(
`name` LIKE "rate#_%" escape "#"
OR `name` LIKE "%#_rate#_%" escape "#" OR
`name` LIKE "% rate %" OR
`name` LIKE "%rate %" OR
`name` LIKE "%#_rate" escape "#"
OR `name` LIKE "%-rate#_%" escape "#"
OR `name` LIKE "rate-" OR
`name` LIKE "rate.%" OR
`name` LIKE "rate-%" OR
`name` LIKE "%-rate-%"
)
AND `key_words` NOT LIKE "%satisfaction%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"satisfaction ")
WHERE
(
`name` LIKE "rating#_%" escape "#"
OR `name` LIKE "%#_rating#_%" escape "#" OR
`name` LIKE "% rating %" OR
`name` LIKE "%rating %" OR
`name` LIKE "%#_rating" escape "#"
OR `name` LIKE "%-rating#_%" escape "#"
OR `name` LIKE "rating-" OR
`name` LIKE "rating.%" OR
`name` LIKE "rating-%" OR
`name` LIKE "%-rating-%"
)
AND `key_words` NOT LIKE "%satisfaction%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"cashback ")
WHERE
(
`name` LIKE "refun#_%" escape "#"
OR `name` LIKE "%#_refun#_%" escape "#" OR
`name` LIKE "% refun %" OR
`name` LIKE "%refun %" OR
`name` LIKE "%#_refun" escape "#"
OR `name` LIKE "%-refun#_%" escape "#"
OR `name` LIKE "refun-" OR
`name` LIKE "refun.%" OR
`name` LIKE "refun-%" OR
`name` LIKE "%-refun-%"
)
AND `key_words` NOT LIKE "%cashback%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"money back ")
WHERE
(
`name` LIKE "refund#_%" escape "#"
OR `name` LIKE "%#_refund#_%" escape "#" OR
`name` LIKE "% refund %" OR
`name` LIKE "%refund %" OR
`name` LIKE "%#_refund" escape "#"
OR `name` LIKE "%-refund#_%" escape "#"
OR `name` LIKE "refund-" OR
`name` LIKE "refund.%" OR
`name` LIKE "refund-%" OR
`name` LIKE "%-refund-%"
)
AND `key_words` NOT LIKE "%money back%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"returns ")
WHERE
(
`name` LIKE "return#_%" escape "#"
OR `name` LIKE "%#_return#_%" escape "#" OR
`name` LIKE "% return %" OR
`name` LIKE "%return %" OR
`name` LIKE "%#_return" escape "#"
OR `name` LIKE "%-return#_%" escape "#"
OR `name` LIKE "return-" OR
`name` LIKE "return.%" OR
`name` LIKE "return-%" OR
`name` LIKE "%-return-%"
)
AND `key_words` NOT LIKE "%returns%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"satisfaction ")
WHERE
(
`name` LIKE "review#_%" escape "#"
OR `name` LIKE "%#_review#_%" escape "#" OR
`name` LIKE "% review %" OR
`name` LIKE "%review %" OR
`name` LIKE "%#_review" escape "#"
OR `name` LIKE "%-review#_%" escape "#"
OR `name` LIKE "review-" OR
`name` LIKE "review.%" OR
`name` LIKE "review-%" OR
`name` LIKE "%-review-%"
)
AND `key_words` NOT LIKE "%satisfaction%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"secured ")
WHERE
(
`name` LIKE "secure#_%" escape "#"
OR `name` LIKE "%#_secure#_%" escape "#" OR
`name` LIKE "% secure %" OR
`name` LIKE "%secure %" OR
`name` LIKE "%#_secure" escape "#"
OR `name` LIKE "%-secure#_%" escape "#"
OR `name` LIKE "secure-" OR
`name` LIKE "secure.%" OR
`name` LIKE "secure-%" OR
`name` LIKE "%-secure-%"
)
AND `key_words` NOT LIKE "%secured%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"trust ")
WHERE
(
`name` LIKE "secure#_%" escape "#"
OR `name` LIKE "%#_secure#_%" escape "#" OR
`name` LIKE "% secure %" OR
`name` LIKE "%secure %" OR
`name` LIKE "%#_secure" escape "#"
OR `name` LIKE "%-secure#_%" escape "#"
OR `name` LIKE "secure-" OR
`name` LIKE "secure.%" OR
`name` LIKE "secure-%" OR
`name` LIKE "%-secure-%"
)
AND `key_words` NOT LIKE "%trust%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"premium ")
WHERE
(
`name` LIKE "shield#_%" escape "#"
OR `name` LIKE "%#_shield#_%" escape "#" OR
`name` LIKE "% shield %" OR
`name` LIKE "%shield %" OR
`name` LIKE "%#_shield" escape "#"
OR `name` LIKE "%-shield#_%" escape "#"
OR `name` LIKE "shield-" OR
`name` LIKE "shield.%" OR
`name` LIKE "shield-%" OR
`name` LIKE "%-shield-%"
)
AND `key_words` NOT LIKE "%premium%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"box ")
WHERE
(
`name` LIKE "shipping#_%" escape "#"
OR `name` LIKE "%#_shipping#_%" escape "#" OR
`name` LIKE "% shipping %" OR
`name` LIKE "%shipping %" OR
`name` LIKE "%#_shipping" escape "#"
OR `name` LIKE "%-shipping#_%" escape "#"
OR `name` LIKE "shipping-" OR
`name` LIKE "shipping.%" OR
`name` LIKE "shipping-%" OR
`name` LIKE "%-shipping-%"
)
AND `key_words` NOT LIKE "%box%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"support ")
WHERE
(
`name` LIKE "suport#_%" escape "#"
OR `name` LIKE "%#_suport#_%" escape "#" OR
`name` LIKE "% suport %" OR
`name` LIKE "%suport %" OR
`name` LIKE "%#_suport" escape "#"
OR `name` LIKE "%-suport#_%" escape "#"
OR `name` LIKE "suport-" OR
`name` LIKE "suport.%" OR
`name` LIKE "suport-%" OR
`name` LIKE "%-suport-%"
)
AND `key_words` NOT LIKE "%support%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"help ")
WHERE
(
`name` LIKE "support#_%" escape "#"
OR `name` LIKE "%#_support#_%" escape "#" OR
`name` LIKE "% support %" OR
`name` LIKE "%support %" OR
`name` LIKE "%#_support" escape "#"
OR `name` LIKE "%-support#_%" escape "#"
OR `name` LIKE "support-" OR
`name` LIKE "support.%" OR
`name` LIKE "support-%" OR
`name` LIKE "%-support-%"
)
AND `key_words` NOT LIKE "%help%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"shipping ")
WHERE
(
`name` LIKE "transport#_%" escape "#"
OR `name` LIKE "%#_transport#_%" escape "#" OR
`name` LIKE "% transport %" OR
`name` LIKE "%transport %" OR
`name` LIKE "%#_transport" escape "#"
OR `name` LIKE "%-transport#_%" escape "#"
OR `name` LIKE "transport-" OR
`name` LIKE "transport.%" OR
`name` LIKE "transport-%" OR
`name` LIKE "%-transport-%"
)
AND `key_words` NOT LIKE "%shipping%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"delivery ")
WHERE
(
`name` LIKE "truck#_%" escape "#"
OR `name` LIKE "%#_truck#_%" escape "#" OR
`name` LIKE "% truck %" OR
`name` LIKE "%truck %" OR
`name` LIKE "%#_truck" escape "#"
OR `name` LIKE "%-truck#_%" escape "#"
OR `name` LIKE "truck-" OR
`name` LIKE "truck.%" OR
`name` LIKE "truck-%" OR
`name` LIKE "%-truck-%"
)
AND `key_words` NOT LIKE "%delivery%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"shipping ")
WHERE
(
`name` LIKE "truck#_%" escape "#"
OR `name` LIKE "%#_truck#_%" escape "#" OR
`name` LIKE "% truck %" OR
`name` LIKE "%truck %" OR
`name` LIKE "%#_truck" escape "#"
OR `name` LIKE "%-truck#_%" escape "#"
OR `name` LIKE "truck-" OR
`name` LIKE "truck.%" OR
`name` LIKE "truck-%" OR
`name` LIKE "%-truck-%"
)
AND `key_words` NOT LIKE "%shipping%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"trusted ")
WHERE
(
`name` LIKE "trust#_%" escape "#"
OR `name` LIKE "%#_trust#_%" escape "#" OR
`name` LIKE "% trust %" OR
`name` LIKE "%trust %" OR
`name` LIKE "%#_trust" escape "#"
OR `name` LIKE "%-trust#_%" escape "#"
OR `name` LIKE "trust-" OR
`name` LIKE "trust.%" OR
`name` LIKE "trust-%" OR
`name` LIKE "%-trust-%"
)
AND `key_words` NOT LIKE "%trusted%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"people ")
WHERE
(
`name` LIKE "user#_%" escape "#"
OR `name` LIKE "%#_user#_%" escape "#" OR
`name` LIKE "% user %" OR
`name` LIKE "%user %" OR
`name` LIKE "%#_user" escape "#"
OR `name` LIKE "%-user#_%" escape "#"
OR `name` LIKE "user-" OR
`name` LIKE "user.%" OR
`name` LIKE "user-%" OR
`name` LIKE "%-user-%"
)
AND `key_words` NOT LIKE "%people%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"eco ")
WHERE
(
`name` LIKE "vegan#_%" escape "#"
OR `name` LIKE "%#_vegan#_%" escape "#" OR
`name` LIKE "% vegan %" OR
`name` LIKE "%vegan %" OR
`name` LIKE "%#_vegan" escape "#"
OR `name` LIKE "%-vegan#_%" escape "#"
OR `name` LIKE "vegan-" OR
`name` LIKE "vegan.%" OR
`name` LIKE "vegan-%" OR
`name` LIKE "%-vegan-%"
)
AND `key_words` NOT LIKE "%eco%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"nature ")
WHERE
(
`name` LIKE "vegan#_%" escape "#"
OR `name` LIKE "%#_vegan#_%" escape "#" OR
`name` LIKE "% vegan %" OR
`name` LIKE "%vegan %" OR
`name` LIKE "%#_vegan" escape "#"
OR `name` LIKE "%-vegan#_%" escape "#"
OR `name` LIKE "vegan-" OR
`name` LIKE "vegan.%" OR
`name` LIKE "vegan-%" OR
`name` LIKE "%-vegan-%"
)
AND `key_words` NOT LIKE "%nature%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"premium ")
WHERE
(
`name` LIKE "vip#_%" escape "#"
OR `name` LIKE "%#_vip#_%" escape "#" OR
`name` LIKE "% vip %" OR
`name` LIKE "%vip %" OR
`name` LIKE "%#_vip" escape "#"
OR `name` LIKE "%-vip#_%" escape "#"
OR `name` LIKE "vip-" OR
`name` LIKE "vip.%" OR
`name` LIKE "vip-%" OR
`name` LIKE "%-vip-%"
)
AND `key_words` NOT LIKE "%premium%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"warranty ")
WHERE
(
`name` LIKE "waranty#_%" escape "#"
OR `name` LIKE "%#_waranty#_%" escape "#" OR
`name` LIKE "% waranty %" OR
`name` LIKE "%waranty %" OR
`name` LIKE "%#_waranty" escape "#"
OR `name` LIKE "%-waranty#_%" escape "#"
OR `name` LIKE "waranty-" OR
`name` LIKE "waranty.%" OR
`name` LIKE "waranty-%" OR
`name` LIKE "%-waranty-%"
)
AND `key_words` NOT LIKE "%warranty%"
successfullyUPDATE `icons`
SET `key_words` = CONCAT(`key_words`,"sport ")
WHERE
(
`name` LIKE "yoga#_%" escape "#"
OR `name` LIKE "%#_yoga#_%" escape "#" OR
`name` LIKE "% yoga %" OR
`name` LIKE "%yoga %" OR
`name` LIKE "%#_yoga" escape "#"
OR `name` LIKE "%-yoga#_%" escape "#"
OR `name` LIKE "yoga-" OR
`name` LIKE "yoga.%" OR
`name` LIKE "yoga-%" OR
`name` LIKE "%-yoga-%"
)
AND `key_words` NOT LIKE "%sport%"
successfully