[SOLVED] Deleting records from multiple tables?

[n8w]

I would like to delete records from multiple tables... I have this tutorial http://www.electrictoolbox.com/article/mysql/cross-table-delete/ .. but still can't figure out the correct syntax for my scenario

 

I want to delete all records with user_id=154 from tables users, illustrators, comments

*note: each table has a user_id column

 

how should I write that?

 

DELETE users.*, illustrators.*, comments.*

FROM users u, illustrators i, comments c

WHERE ????

 

 

[gassaz]

Something like this:

 

DELETE users.*, illustrators.*, comments.*
FROM users u
INNER JOIN illustrators i ON u.user_id = i.user_id
INNER JOIN comments c ON u.user_id = c.user_id
WHERE u.user_id = ???

[n8w]

thanks soooooooooo much .. this rules!