Hi list. Can someone give me a working example of a SQL CASE statement(in SELECT)? I have examples for stored procedures, but none for use within the DML side of SQL.
I am trying to in my SELECT (used in PHP) create a variable/col for example: status='high' where value in a other col is withinin certain range. I am sure that I do not have the order of the syntax or complete code. I am using MySQL 4.0.17, and a newbie. Any simple example will help. Please note I am not requesting for use within a procedure or trigger, etc, just a simple DML side SELECT. TIA RS This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]