Move profile field8 by sql query

[woostar]

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 :)

[Dismounted]

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

[woostar]

nope :( - soooo close.

any other idea's :D

[Opserty]

Other way round... :D

UPDATE user
LEFT JOIN userfield USING (userid)
SET user.usertitle = userfield.field8

[Dismounted]

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

[woostar]

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