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
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 this. The databa
