stripping capital letters from everything in a collum in the database : I know lots of people have answered this question but i am following the guides but im getting nowhere

im currently using 

    UPDATE buinesses SET BusinessType=LOWER(BusinessType)

I have want to stip all of the caps from the business names for example:

I would like 'Cafe and Post Office' to be 'cafe and post office'

Hope someone can help

I would do this manually but i have over 500 business types in my database

Thank you for any help
