SQL request to get the log of a user by his user name

Hi everyone,

I want to get all the connexion log of one user by his user name. To do that , I make a sql request like this " Select * from $log  where ..." I don't know exactly what to put in the where clause to filter by user name . Can you help me please.

Regards.