All of our records (30-40 k) got uploaded with non descriptive titles in a certain channel and I want to properly rename them in either Sequel Pro or EE. I haven't used SQL in a while so I need help creating the proper code.
I'm hoping to have the title and title_url values regenerated based on values of other fields.
Basically I want to be able to do things like: If field_id_91 =  [vogue-pattern-company] Vogue Pattern Company then title should be "Vogue field_id_40 (field_id_41)"
Thanks in advance!