mysql> select distinct type_status, type_order_delivery, type_order_taken from orderheader; +-------------+---------------------+------------------+ | type_status | type_order_delivery | type_order_taken | +-------------+---------------------+------------------+ | NULL | NULL | NULL | | NULL | post | NULL | | NULL | post certified | NULL | | NULL | ups ground | NULL | | NULL | ups next day | NULL | | NULL | fedex ground | NULL | | NULL | fedex next day | NULL | | NULL | truck | NULL | | NULL | vendor | NULL | | NULL | NULL | fax | | NULL | NULL | phone | | NULL | NULL | email | | NULL | NULL | online | | NULL | NULL | mail | | pending | NULL | NULL | | active | NULL | NULL | | completed | NULL | NULL | | cancelled | NULL | NULL | +-------------+---------------------+------------------+