To delete records in the bmh_woocommerce_sessions
table where the session_key
starts with t_
, you can use the following SQL query:
Explanation:
DELETE FROM bmh_woocommerce_sessions
: Deletes rows from thebmh_woocommerce_sessions
table.WHERE session_key LIKE 't_%'
: Filters rows where thesession_key
starts witht_
. The%
wildcard matches any number of characters followingt_
.
Make sure you back up your database before running the query, as DELETE
operations are irreversible.