| 1 | UPDATE profile_public_names |
| 2 | SET lastname_main = REPLACE(lastname_main, ' ', ' ') |
| 3 | WHERE lastname_main LIKE '% %'; |
| 4 | |
| 5 | UPDATE accounts AS a |
| 6 | INNER JOIN account_profiles AS ap ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms)) |
| 7 | INNER JOIN profile_public_names AS ppn ON (ppn.pid = ap.pid) |
| 8 | INNER JOIN profile_display AS pd ON (pd.pid = ap.pid) |
| 9 | SET a.lastname = IF(ppn.lastname_ordinary = '', ppn.lastname_main, ppn.lastname_ordinary) |
| 10 | WHERE a.type IN ('x', 'master', 'phd'); |
| 11 | |
| 12 | -- vim:set syntax=mysql: |