is it safe to delete all transients code example

Example: remove transient options sql wordpress

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