another example<http://mysql-tips.blogspot.com/2005/04/mysql-select-case-example.html> ============ regds amit "The difference between fiction and reality? Fiction has to make sense." On Thu, Oct 13, 2011 at 9:34 AM, Amit Tandon <attand@xxxxxxxxx> wrote: > select case<http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html> works in mysql also > ============ > regds > amit > > "The difference between fiction and reality? Fiction has to make sense." > > > > On Thu, Oct 13, 2011 at 3:26 AM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote: > >> Hi >> >> In Oracle (and maybe others) you can use >> >> >> select case >> when answer=1 >> then trivia_answer_1 >> when answer=2 >> then trivia_answer_2 >> when answer=3 >> then trivia_answer_3 >> when answer=4 >> then trivia_answer_4 >> else null >> end answer >> from bible_trivia_table >> OR >> >> You can select all of them and process in PHP, should not be too hard to >> come up with a couple of lines of code to display only 1 variable based >> on >> the value of variable 5. Overhead should be pretty minimal as well >> You'll be writing something to display a value anyway >> >> >> Jack van Zanen >> >> ------------------------- >> This e-mail and any attachments may contain confidential material for the >> sole use of the intended recipient. If you are not the intended recipient, >> please be aware that any disclosure, copying, distribution or use of this >> e-mail or any attachment is prohibited. If you have received this e-mail >> in >> error, please contact the sender and delete all copies. >> Thank you for your cooperation >> >> >> On Thu, Oct 13, 2011 at 6:24 AM, Ron Piggott < >> ron.piggott@xxxxxxxxxxxxxxxxxx >> > wrote: >> >> > >> > In my Bible_Trivia table I have the columns >> > >> > `trivia_answer_1`, `trivia_answer_2`, `trivia_answer_3`, >> `trivia_answer_4`, >> > `answer` >> > >> > `answer` is an integer always with a value of 1 to 4. Is there a way to >> use >> > the value of `answer` to only select the correct trivia answer? >> > >> > This doesn’t work, but this is the idea I am trying to achieve: >> > >> > SELECT `trivia_answer_`answer`` FROM `Bible_trivia` >> > >> > Thanks in advance, >> > >> > Ron >> > >> > >> > >> > www.TheVerseOfTheDay.info <http://www.theverseoftheday.info/> >> > >> > >
