Re: SELECT syntax

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@gmail.com> wrote: > select case<’ù > )EßHnå^h˜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, >> > 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/> >> > >> > >