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/> > > >
