Conversion in an INSERT query

Hi there!

I need to know how to have automatically the name "BROWN" (example) inserted this way: "Brown".

The query is a classical and simple query:

INSERT INTO `list`(`ID`, `lastName`, `firstName`, `school`, `year`) VALUES ([""],[BROWN],[JOHN],[Snowy Mountain],[1985])

ID is AUTOINCREMENT

Result should be:

93, Brown, John, Snowy Mountain, 1985

I need this tip because I have almost 3000 queries like this to execute and all the names are in caps!!!

Many thanks in advance for your help!

 

After insert those queries you can update firstName and lastName column to change the case....

for lastName column:
UPDATE school SET lastName = CONCAT(UCASE(LEFT(lastName, 1)), LCASE(SUBSTRING(lastName, 2)));
for firstName column:
UPDATE list SET firstName = CONCAT(UCASE(LEFT(firstName, 1)), LCASE(SUBSTRING(firstName, 2)));

regards

--amrush

 

If you're doing this in a language that has decent string manipulation, you can ProperCase() the data as part of the query:

$insertString = "INSERT INTO `list`(`lastName`, `firstName`, `school`, `year`) VALUES (ProperCase('BROWN') & "," & ProperCase('JOHN') & ",[Snowy Mountain],[1985])"

Code (markup):

The exact syntax would depend on the language.

 

strtoupper("bRowN")
output : BROWN

 

Thank you very much, it works nice!