I have a random group of about 40 entries in the same channel where I need to copy the
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.