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 * FROMBut it isnt right, can anyone tell me the correct syntax.cscart_orders
.user_id
‘0’
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