Can I launch a trigger on select statement in mysql?

Nope - you can't trigger on SELECT - you'll have to create a stored procedure (or any other type of logging facility - like a log file or what ever) that you implicitly call on any query statement - easier if you create a wrapper that calls your query, calls the logging and returns query results.

Short answer is No. Triggers are triggered with INSERT, UPDATE or DELETE.

Possible solution for this. rather rare scenario:

• First, write some stored procedures that do the SELECTs you want on table X.
• Then, restrict all users to use only these stored procedures and do not allow them to directly use SELECT on table X.
• Then alter the stored procedures to also call a stored procedure that performs the action you want (INSERT or whatever).