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 + MySQL + PHP on Win32),
but mysql returns error at the third parameter. It expected to use the
DECODE decryption function which needs only 2 parameters.

How can I perform this trigger without using another table?

Regards,
__________________
Mahefa RANDIMBISOA 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to