Skip to content

Instantly share code, notes, and snippets.

@simbus82

simbus82/My Maps Location + K2 items

Created February 17, 2016 15:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save simbus82/af3bd7317175edcd04c6 to your computer and use it in GitHub Desktop.
Save simbus82/af3bd7317175edcd04c6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
My Maps Location + K2 items
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