Re: Help - select syntax if else

On 8 Jan 2003, at 15:27, Svens Klave wrote: > | image | check | > | 6782 | 0 | > | 2732 | 1 | > | 6734 | 1 | > > so I want to make query > select * from foo1 where [so is it possible to make some if check=1 then > image is image but if check=0 then into image goes othe

Re: Help - select syntax if else

On Wed, Jan 08, 2003 at 03:27:51PM +0200, Svens Klave wrote: > > Can anybody help me > with select query > > how to do this: > > I have table "foo1" with two fields "image" "check" > > | image | check | > | 6782 | 0 | > | 2732 | 1 | > | 6734 | 1 | > > so I want to ma

Re: Help - select syntax if else

* Svens Klave > Can anybody help me > with select query I can try. > how to do this: > > I have table "foo1" with two fields "image" "check" > > | image | check | > | 6782 | 0 | > | 2732 | 1 | > | 6734 | 1 | > > so I want to make query > select * from foo1 where [so is

Re: Help - select syntax if else

You don't even need the "check" field you can just directly check the contents of the image field. Although I'm not sure if you are trying to set a filter or display something different. If you want to display a conditional on a field then you need to specify that field directly. select *,if(im

Help - select syntax if else

Can anybody help me with select query how to do this: I have table "foo1" with two fields "image" "check" | image | check | | 6782 | 0 | | 2732 | 1 | | 6734 | 1 | so I want to make query select * from foo1 where [so is it possible to make some if check=1 then image