From: cl
Date: February 5 2013 2:49pm
Subject: =?utf-8?B?U0VMRUNUIHN1YnF1ZXJ5IHByb2JsZW0=?=
List-Archive: http://lists.mysql.com/mysql/228928
Message-Id: <20130205144947.15270.qmail@s464.sureserver.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

De-lurking here.

I am trying to figure out how to return results from a query. What I need to do is to return 4 columns from a database. This is easy:

SELECT last_name, first_name, phone, email FROM `mydatabasetable` WHERE `current_member` = "Y" AND `pub_name` = "Y" ORDER BY last_name ASC

This works fine, as expected.

But, I want to only display the value in `email` if the value in another field, `pub_email` = "Y"  So, the resultant output would look like this, for instance, if the value of `pub_email` ="N" for Mr. Wills:

Jones  John     555-555-5555   johnjones@stripped
Smith  Jim       555-222-2222   jimSmith@stripped
Wills    Chill      555-111-1111
Zorro  Felicity  555-999-9999  felicityzorro@stripped

Can't quite figure out how to express this.

TIA for your suggestions!