Filter Guest Orders In Phpmyadmin

Multi-Vendor in detail Configuration: How-tos, questions, issues
#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