Take the 2-minute tour ×

Is there a way to force all entries in a particular field to be lower case across an entire table in one command?

share|improve this question
add comment

3 Answers

up vote 2 down vote accepted
UPDATE table SET column = LOWER(column);
share|improve this answer
add comment

It sounds like you want a statement to force a column's alpha characters to be all lower cased.

SET MyColumn = LOWER(MyColumn)
share|improve this answer
add comment

You can change all the data after the fact with an update:

update `your_table` set column=lower(column);

But as far as forcing this upon insert Im not sure.

share|improve this answer
add comment

Your Answer


