Move profile field8 by sql query
 

Hi all :D

need a hand if anyone can help.

I want to do a sitewide move of:-
User Profile Fields (field8)
into 'user' table 'usertitle'

So that's every members 'field8' into their 'usertitle'.

Problem is I can't find 'User Profile Fields (field8)'
Can anyone help me with the query I can insert into phpmyadmin?

Thanks in advance :)

[sql]UPDATE user
SET user.usertitle = userfield.field8
LEFT JOIN userfield USING (userid)[/sql]
Not tested, so you might want to try on a test board first.

nope :( - soooo close.

any other idea's :D

Other way round... :D

[sql]UPDATE user
LEFT JOIN userfield USING (userid)
SET user.usertitle = userfield.field8[/sql]

Ah, that's right. I always confuse the order on an update.

Beautiful, worked like a charm. Thank you both for your help :)