Hi

Does mysql accept the in clause in update queries like the example below ?

UPDATE
role_assignments
SET
enrol='database'
WHERE
userid IN (
SELECT DISTINCT (
u.id
)
FROM mdl_user u
INNER JOIN role_assignments ra ON ra.userid = u.id
INNER JOIN context ct ON ct.id = ra.contextid
INNER JOIN course c ON c.id = ct.instanceid
INNER JOIN role r ON r.id = ra.roleid
INNER JOIN course_categories cc ON cc.id = c.category
AND SUBSTRING( cc.path, 1, 2 ) = '/2'
WHERE r.id =5
AND cc.name <> '2008/2'
)