How to enable logs for error generating or failed queries ?

[shinigami017]

I want to enable logs for failed or error generating queries not all the queries. Something like logging stats_mysql_errors table.

I can get the output of query select * from stats_mysql_errors; in a file but it will be manual work everytime I want to fetch the logs for failed queries. So, is there any way to log all the failed queries or sql errors automatically in real-time?