September 25th, 2012, 12:02 PM
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, 12:18 PM
You would do that in your front end application, not within mysql.
September 25th, 2012, 12:20 PM
Originally Posted by Guelphdad
hmmm...thought so...just wanted to confirm it once...thanks