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
technologies.
GOD BLESS AMERICA!
To God Be The Glory!
-Original Message-
From: Rafi Sheikh [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 12:21 PM
To: '[EMAIL PROTECTED]'
Subject: MySQL SQL Case Stetement
Hi list. Can someone give me a working example of a SQL CASE
The CASE function is documented in the manual
http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html.
SELECT CASE
WHEN other_col 100 THEN 'low'
WHEN other_col BETWEEN 100 AND 1000 THEN 'medium'
WHEN other_col 1000 THEN 'high'
END AS col
FROM your_table;
Michael
Rafi