Try using a CASE construct in the select. Should work for this. A
On Tue, Feb 5, 2013 at 3:25 PM, Stefan Kuhn <stef...@web.de> 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 <c...@nimbleeye.com> > An: mysql@lists.mysql.com > 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 johnjo...@nowhere.com > Smith Jim 555-222-2222 jimsm...@nothing.com > Wills Chill 555-111-1111 > Zorro Felicity 555-999-9999 felicityzo...@madeup.com > > 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 > >
