SQL Statement request for albums problems with deleted users
 

Hi,

we deleted users and the existing albums are still online which is fine.
But the userID should set to eg "100" as universal user for all deleted userid.

My skills in MySQL are not so good, so I would like to ask if somebody can help me with the following:

Code:
UPDATE album,user SET album.userid = 100 WHERE user.userid ...
The questions is how to request that the userID is not existing. I found some ways in the documentation (for example NOT IN, EXISTS), but I am not able to get them run correctly.

Thanks
André