On Wed, 30 Jun 2004, Aaron Wolski wrote:
> Hi Guys,
>
> I'm trying to figure out of this is possible. I know I could do it in
> PHP but I am dealing with a ton of records and would rather put the
> processing on the DB than PHP/client side.
>
> Question is. can I do a SELECT query on a column that
ndet: Mittwoch, 30. Juni 2004 18:46
> An: [EMAIL PROTECTED]
> Betreff: making lower case then first char to upper case?
>
> Hi Guys,
>
> I'm trying to figure out of this is possible. I know I could
> do it in PHP but I am dealing with a ton of records and would
> r
Someone else hopefully has something more efficient:
UPDATE table SET field = CONCAT( UPPER( LEFT( field, 1 ) ), LOWER(
SUBSTRING( field, 2 ) ) )
Wes
On Jun 30, 2004, at 12:46 PM, Aaron Wolski wrote:
Hi Guys,
I'm trying to figure out of this is possible. I know I could do it in
PHP but I am deali
Hi Guys,
I'm trying to figure out of this is possible. I know I could do it in
PHP but I am dealing with a ton of records and would rather put the
processing on the DB than PHP/client side.
Question is. can I do a SELECT query on a column that changes all the
results to lower case and THEN chan