I have the following table layout
1 lucent test MC email@example.com Y
2 lucent test ST firstname.lastname@example.org
3 lucent test1 DR email@example.com
What i want to do is if YESorNO = Y and Vendor = lucent i need the emailaddress to all switches that are the same as the ID 1
So after my query i need the following
here is the code that i got so far but if only gives me information for ID 1
SELECT * FROM `MailingList` WHERE `Vendor`='lucent' AND `yesorno` = 'Y'