Change case of a whole column. 1

[Sleidia]

Hello,

Could someone tell me if there is any way to
make a whole column become uppercase or lowercase only
with a single mysql function???
I've bees searching for a long...long..time, but
I can't find it. It doesn't exist perhaps.

Thanks a lot.

 

[Tim1]

Hiya,

You should be able to, try the keywords UPPER or LOWER, the Syntax is

UPPER (column_name)
LOWER (column_name)

HTH

Tim

 

[Sleidia]

Thanks for you very quick reply Tim1 !

I've tried your idea, but it didn't work.
I've forgotten to say that I want all the data of the column to become uppercase, but not the name of the column only.
But I am sure you understood well....

Anyway, thanks again and have a good day.

 

[rouse01]

I think what Tim1 meant was to use the command like:
"select upper(column_name) from table"
You could then try;
"update table replace column_name with upper(column_name)"

I'd like to know if there is a function like proper(), like in foxpro?

Hope this works

 

[Sleidia]

Hello and thank you for your advices which helped me
to find the proper command.

Here it is:
UPDATE table SET column_name = upper(column_name) WHERE ...etc..etc

I hope it will be useful to someone else.
See you.