How to find status of registrants in MySQL table

Hi Tuan,
For some reason we need to exclude registrants that are cancelled from a statistics calculation. I cannot find what changes are done to the eb_registrants table when a persons status changes?
Or lets say it like this... How can I see a registrants status solely by looking at the MySQL table?

Thanks
Tim

Hello Tim

It is controlled by published field. When the registration cancelled, the published field of the record will be set to 2

Hope it helps

Tuan