I've scoured the docs in the past for the same function you are seeking. MySQL doesn't not have such a function.
Since MySQL does support regex string manipualtion, I did look into trying to produce the results using MySQL regex
string functions, but I quickly learned that it's far to complicated to do it in MySQL. It's far easier to do it in
whatever script language your using (Perl, PHP, etc).
Peter
On 22 Sep 2003 at 14:33, Mike Starke wrote:
>
> Is there a function in MySQL similar to that in Excel's "proper()"?
>
> For instance, I would like to do a select on a column that has
> all CAPS and display the query in proper case (Mike versus MIKE).
>
> --
> -Mike
>
> :wq!
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)