Move profile field8 by sql query

[woostar]

Hi all

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]

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

[woostar]

nope - soooo close.

any other idea's

[Opserty]

Other way round...

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

[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