Re[2]: MySQL Feature

2003-02-13 Thread Stefan Hinz
Luc, Zak, >> SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable > You can use a WHERE clause to get an effect like this. > SELECT CASE expression > WHEN 'value' > THEN column > ... > ELSE 'default result' > END > FROM Tabl

Re[2]: MYSQL Feature :)

2001-03-01 Thread Peter Zaitsev
Hello Sinisa, Thursday, March 01, 2001, 3:42:46 PM, you wrote: SM> > I'm not really shure if this is a bug or correct behavior, but still SM> > it leads to toe problems in this case: SM> > SM> > insert into g02layers_stat_hits set counter=1, type=1, page_group=1; SM> > ERROR 1062: Duplicat