Figured out the SQL query that can be used to reset the display_name
to first_name + last_name
. And it’s simpler than the JOIN
s that I was trying when I posted the question.
UPDATE wp_users
SET display_name = Concat(
(SELECT meta_value
FROM wp_usermeta
WHERE meta_key = 'first_name'
AND user_id = id
),
' ',
(SELECT meta_value
FROM wp_usermeta
WHERE
meta_key = 'last_name'
AND user_id = id
)
);