Federal Posted August 31, 2008 Share Posted August 31, 2008 Suppose I have a table as follows: ID VAR1 VAR2 VAR3 01SundayPortland 11TuesdayThe Hague 20FridayOttawa 31MondayBangkok I'd like to set it up so that, if VAR1 = 1, it returns VAR2, while if VAR1 = 0, it returns VAR3. Is this possible using mySQL alone, and without adding additional tables? I can work out a PHP-based solution involving seperating them into different tables (VAR1 on one table, VAR2 and VAR3 on another), but that would be inefficient. Edit: mySQL 5.0 Link to comment https://forums.phpfreaks.com/topic/122055-conditions-within-conditions-within-select-query/ Share on other sites More sharing options...
Federal Posted August 31, 2008 Author Share Posted August 31, 2008 Wait, I'm an idiot. I'm already doing SELECT *, so I can suss it out using PHP anyway. Durrr. Link to comment https://forums.phpfreaks.com/topic/122055-conditions-within-conditions-within-select-query/#findComment-630078 Share on other sites More sharing options...
fenway Posted August 31, 2008 Share Posted August 31, 2008 I don't know what you're trying to do, but IF() expressions can help in sql. Link to comment https://forums.phpfreaks.com/topic/122055-conditions-within-conditions-within-select-query/#findComment-630491 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.