Filter Guest Orders In Phpmyadmin

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

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

Please try

SELECT * FROM `cscart_orders` WHERE user_id = 0;

Please have a look on our Extended orders search addon