How do you get the number of rows affected by query?

SELECT COUNT (user_id) FROM users would only return the number of user_id’s.