I have a random group of about 40 entries in the same channel where I need to copy the url_title
from exp_channel_titles
over to the uri
column in exp_structure_listings
. If I wanted to copy the urls for all entries there'd be no problem, but I need to copy only the urls from this specific group of entry IDs. I tried:
UPDATE
exp_structure_listings s, exp_channel_titles t
SET
s.uri = t.url_title
WHERE
s.entry_id = t.entry_id
AND
t.channel_id = '17'
AND (
t.entry_id = '2128'
OR t.entry_id = '2142'
OR t.entry_id = '2171'
)
But, not surprisingly, that didn't work. I feel like I should be using a join in here somewhere but I'm not really sure what the syntax should look like.