Filter Guest Orders In Phpmyadmin

Multi-Vendor Questions
1

I’m trying to filter guest orders in phpmyadmin to delete them and bring my database size down from 2.5gb

Im trying sql

SELECT * FROM cscart_orders .user_id ‘0’
But it isnt right, can anyone tell me the correct syntax.

According to the docs, 0 is the guest user https://prnt.sc/mslc9l

would also appreciate a tip on to how to delete only those more then 1 year old.
JOhn

2

Please try

SELECT * FROM `cscart_orders` WHERE user_id = 0;
3

Please have a look on our Extended orders search addon