Clear WordPress Transients from MySQL

Ok, there are times you like to clear the Transients for the WordPress, and you try to use the internal commands of the WordPress.

Here is a MySQL Query that clear any transient:

DELETE FROM `PREFIX_options` WHERE `option_name` LIKE ('%_transient_%');

Change PREFIX_ with the prefix used in your WordPress installation.