Re: DECODE, not to decrypt but as trigger

2004-02-26 Thread Egor Egorov
"Mahefa Randimbisoa\\DS-ETU" <[EMAIL PROTECTED]> wrote: > You should know the meaning of next SQL statements : > > SELECT DECODE(field_name, '0', 'Sunday', '1', 'Monday', '2', 'Tuesday') > FROM table_name > > (This should mean : if field_name = '0', return 'Sunday', if field_name = > '1', returns

DECODE, not to decrypt but as trigger

2004-02-26 Thread Mahefa Randimbisoa\\DS-ETU
Hi! You should know the meaning of next SQL statements : SELECT DECODE(field_name, '0', 'Sunday', '1', 'Monday', '2', 'Tuesday') FROM table_name (This should mean : if field_name = '0', return 'Sunday', if field_name = '1', returns 'Monday', ...) I try to use this with mysql (in EasyPHP: Apache