Delete records in the bmh_woocommerce_sessions table where the session_key starts with t_

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 the bmh_woocommerce_sessions table.
  • WHERE session_key LIKE 't_%': Filters rows where the session_key starts with t_. The % wildcard matches any number of characters following t_.

Make sure you back up your database before running the query, as DELETE operations are irreversible.

    
DELETE FROM `bmh_woocommerce_sessions` WHERE `session_key` LIKE 't_%';

Leave a Reply