How to look up a user based on a user_id?

[fefrei (Felix Freiberger)]

Alternatively, you can use the awesome Data Explorer plugin:

SELECT *
FROM users
WHERE id = 398