Re: SELECT syntax

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@vanzanen.com> 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@actsministries.org > > wrote: > > > > > In my Bible_Trivia table I have the columns > > > > trivia_answer_1, b4''!lä > > ×ÛãØØ·™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/> > > >