• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Help with MySQL query

#1
I need to carry over values from one custom user field to another one. Some members have that field filled out and others don't. What query should I run for this? And is queries the only way to do it or is there also something in the AdminCP that can accomplish this?
 

Mouth

Well-known member
#4
update a
set a.field_value = z.field_value
from xf_user_field_value as a
inner join xf_user_field_value z on a.user_id = z.user_id
where a.field_id = '[Field ID of the target]' and
z.field_id = '[Field ID of the source]'