Posts: 2,389
Name: <member type="brilliant" alt="foolish">James Lewitzke</member>
Location: / public_html / Universe / Virgo_Supercluster / Local_Group / Milky_Way / Orion_Arm / Solar_System / Earth / North_America / USA / Wisconsin
|
Thanks for all the help. I just had to change the u.id to userid to get it to work right (as the table only had the userid column):
PHP Code:
UPDATE user as u
LEFT JOIN userfield as uf ON uf.userid = u.userid
SET u.usergroupid = 9
WHERE instr(uf.field1,"man");
Last edited by jamestl2; 02-02-2009 at 02:33 AM..
|
