1. 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

Discussion in 'XenForo Questions and Support' started by JackieChun, Oct 29, 2015.

  1. JackieChun

    JackieChun Active Member

    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?
  2. JackieChun

    JackieChun Active Member

  3. JackieChun

    JackieChun Active Member

  4. Mouth

    Mouth Well-Known Member

    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]'

Share This Page