Searching For Customers Without Blank Company Field

General Forums General Questions
#1

Hi,

Is there a way to filter out customers that have something entered in company name??

Thanks - Adam.

#2

Not from cs-cart itself that I'm aware of, but to get the emial addresses of users that have a non-empty company field is a pretty simple SQL statement.

SELECT email FROM cscart_users WHERE company != ''

NOT TESTED