Re: if else statement

fre 2006-06-23 klockan 01:52 -0400 skrev Michael Stassen: > Thomas Lundström wrote: > > Not sure what you're aming for here and how your data is structured but > > why not use a join and alias and fetch all info in one select and then > > solve what you need in your code? > > > > Something in

Re: if else statement

Song Ken Vern-E11804 wrote: > Hi, > > I'm trying to build a query in using SQL instead of doing it in Perl. > > I am trying to do something like this : > > If ((select col1 from table1 where id = 1) == 3) > Then > Select col2 from table2 where table2.id = 1; > Else > Select col2 from table3 where

RE: if else statement

is. Examples only show numeric and string functions. -Original Message- From: Peter Lauri [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 4:43 PM To: [EMAIL PROTECTED]; Song Ken Vern-E11804 Cc: mysql@lists.mysql.com Subject: RE: if else statement SELECT IF(col1=3, (Select col2 f

RE: if else statement

Cc: mysql@lists.mysql.com Subject: Re: if else statement Not sure what you're aming for here and how your data is structured but why not use a join and alias and fetch all info in one select and then solve what you need in your code? Something in the line of: select t2.col2 from_t2, t3

Re: if else statement

Not sure what you're aming for here and how your data is structured but why not use a join and alias and fetch all info in one select and then solve what you need in your code? Something in the line of: select t2.col2 from_t2, t3.col2 from_t3 from table1 t1, table2 t2, table3 t3 where t1.id = t

Re: if else statement

On Wednesday 21 June 2006 11:16, Song Ken Vern-E11804 wrote: > Hi, > > I'm trying to build a query in using SQL instead of doing it in Perl. > > I am trying to do something like this : > > If ((select col1 from table1 where id = 1) == 3) > Then > Select col2 from table2 where table2.id = 1; > Else

if else statement

Hi, I'm trying to build a query in using SQL instead of doing it in Perl. I am trying to do something like this : If ((select col1 from table1 where id = 1) == 3) Then Select col2 from table2 where table2.id = 1; Else Select col2 from table3 where table3.id = 1; In Perl I would probably do

Re: If Else statement

rver 10.2, so if the suggestion you gave me is the only way (or the best) I will have to upgrade the server. If there is another way to do the same thing, please let me know. Mike > From: Egor Egorov <[EMAIL PROTECTED]> > Date: Mon, 26 Jan 2004 15:40:54 +0200 > To: [EMAIL PROTE

Re: If Else statement

Mike Tuller <[EMAIL PROTECTED]> wrote: > I am trying write a shell script to check to see if a record exists and if > it does, update information, and if it doesn't insert information. Is there > a way to do an if else statement in MySql? > If you have PRIMARY KEY or UNIQU

If Else statement

I am trying write a shell script to check to see if a record exists and if it does, update information, and if it doesn't insert information. Is there a way to do an if else statement in MySql? I'm stuck on how to do this. I don't want to write it in perl. Mike -- MySQL Gener