List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:February 5 2013 3:43pm
Subject:Re: SELECT subquery problem
View as plain text  
Try using a CASE construct in the select. Should work for this.

A


On Tue, Feb 5, 2013 at 3:25 PM, Stefan Kuhn <stefhk3@stripped> wrote:

> You cannot do this. A sql result alwas has the same number of columns in
> each row. You could have null or "" in the column, though. This could be
> done via the if(,,)-statement of mysql or by using a union and two selects,
> one for pub_email=n and the other for the rest.
>
>
> Gesendet: Dienstag, 05. Februar 2013 um 15:49 Uhr
> Von: cl <cl@stripped>
> An: mysql@stripped
> Betreff: SELECT subquery problem
> 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!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql[http://lists.mysql.com/mysql]
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
SELECT subquery problemcl5 Feb
  • RE: SELECT subquery problemCarlos Eduardo Caldi5 Feb
    • RE: SELECT subquery problemcl6 Feb
  • Aw: SELECT subquery problemStefan Kuhn5 Feb
    • Re: SELECT subquery problemAndrew Moore5 Feb
  • Re: SELECT subquery problemAndy Wallace5 Feb