September 25th, 2012, 11:02 AM
Help for coloring the column
I am new to databases and want help in below code:
(CASE WHEN power<30 THEN (power,"Red") ELSE POWER
What I want is if the column 'power' has value less than 30 then I want to display those values in Red color, else I want to print it as it is.
Output should look like this:
Is it something possible in MySQL?If yes, what is the correct syntax for it as I know the code printed in blue color is not correct and giving me an error?
September 25th, 2012, 11:18 AM
You would do that in your front end application, not within mysql.
September 25th, 2012, 11:20 AM
Originally Posted by Guelphdad
hmmm...thought so...just wanted to confirm it once...thanks