SQL - work around

[samatair]

UPDATE users set user_type='CLIENT' where user_id in (SELECT user_id FROM clients)

The above query is not working with MYSQL version 4.xx, is there a work around for this.

[Atli]

You could try an INNER JOIN.

Like:

UPDATE userTable AS u
INNER JOIN clientTable AS c
    ON u.ID = c.ID
SET u.UserType = 'Client';
 

[samatair]

Thank you Atli. But it also gives
Error:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[mwasif]

Try this one

UPDATE users, clients SET users.user_type='CLIENT' 
WHERE users.user_id = clients.user_id

[Atli]

@samatair
Weird. It worked for me.
I didn't use the same names as you did tho, so make sure you didn't accidentally mess up the syntax when you edited it. (Assuming you did actually edit it?)

The query mwasif posted should work to tho, and he uses that same names you did.
Try that and see what happens.

[samatair]

Great! mwasif's query worked fine. Thank you very much.
Thank you too Atli for the follow up and suggestions.
You both were so helpful.

Thanks once again!