delete all transients wordpress code example

Example: remove transient options sql wordpress

DELETE FROM `wp_options` WHERE `option_name` LIKE ('%\_transient\_%')