DELETE FROM `wp_options` WHERE `option_name` = '_transient code example

Example: remove transient options sql wordpress

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