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 Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.