Syndicate content

Reply to comment

MySQL column to lower [SOLVED]

If you are working in a MySQL database and you want to make all rows in column to lower case for a specific table then you can do it like this:
UPDATE tablename SET columnname = LOWER(columnname);
And you're done!

Reply

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote> <abbr>
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. The supported tag styles are: <foo>, [foo].

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
* four = 16
Solve this math question and enter the solution with digits. E.g. for "two plus four = ?" enter "6".