UPDATE species SET species_name =
CONCAT(
UCASE(LEFT(species_name, 1)),
RIGHT(species_name, LENGTH(species_name)-1)
);
Should work, but didn't tested.
Tyrael
On Wed, Apr 7, 2010 at 8:12 AM, Bill Mudry wrote:
> Tyrael also suggested that and it worked! :-) .
> That sure beats manually goi
Tyrael also suggested that and it worked! :-) .
That sure beats manually going through 6,500 records!
Now I need a statement (UPDATE or SELECT SET?) to permanently correct
all entries in the
species_name column. I tried both but do not have my syntax quite right.
Bill
At 02:08 AM 07/04/2010,
> I have a MySQL file that is filled with information on the different
> woods of the world.
> In one column for the botanical species names, some of the first
> characters in each
> record are not capitalized when they should all be while many are
> properly capitalized.
> I need to correct thi
On Wed, Apr 7, 2010 at 7:42 AM, Bill Mudry wrote:
> I have a MySQL file that is filled with information on the different woods
> of the world.
> In one column for the botanical species names, some of the first characters
> in each
> record are not capitalized when they should all be while many ar
