RE: Re: query to lowercase database columns names

2005-05-11 Thread mfatene
Selon Jay Blanchard <[EMAIL PROTECTED]>: > [snip] > I've got a converted from Excel spreadsheet to mysql database, which has > mixed case column names and > also columns beginning with a digit eg 01_name, 02_address etc what > upsets PHP considerably. > > So I'd like to have a way to generically r

RE: Re: query to lowercase database columns names

2005-05-11 Thread Jay Blanchard
[snip] I've got a converted from Excel spreadsheet to mysql database, which has mixed case column names and also columns beginning with a digit eg 01_name, 02_address etc what upsets PHP considerably. So I'd like to have a way to generically rename all columns beginning with a numeric form ^\d.*