Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
UPDATE
s1du4_mymaplocations_location, s1du4_k2_items
SET
s1du4_mymaplocations_location.extra_id = s1du4_k2_items.id
WHERE (
s1du4_mymaplocations_location.catid = 8
AND
s1du4_k2_items.catid = 154
AND
s1du4_mymaplocations_location.name LIKE CONCAT('%', s1du4_k2_items.title ,'%')
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment