1 UPDATE profile_public_names
2 SET lastname_main
= REPLACE(lastname_main
, ' ', ' ')
3 WHERE lastname_main
LIKE '% %';
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');
12 -- vim:set syntax=mysql: