Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    3

    Unanswered: convert all column records to lowercase?

    hi,
    SQL newbie here...using MySQL to be exact.
    i want to convert a column of emails to be all lowercase.
    is this possible?
    i've searched this and other forums to no avail.
    thanks for your help

  2. #2
    Join Date
    May 2004
    Location
    NJ USA
    Posts
    21
    Of course you can:

    Try using the LOWER Function when updating your field.
    J.D.
    Database Administrator

  3. #3
    Join Date
    Jun 2004
    Posts
    3
    thanks, but maybe i wasn't clear.
    i have a whole table already filled with data and i need to run a script that updates all of the exisiting data in a column and converts all the data to lowercase.
    i'm an SQL newbie...is this possible?
    something like:
    UPDATE table SET column = LOWER() ???

  4. #4
    Join Date
    Apr 2004
    Location
    Europe->Sweden->Stockholm
    Posts
    71
    Quote Originally Posted by dugawug
    something like:
    UPDATE table SET column = LOWER() ???
    UPDATE table SET column=LOWER(column) ?

  5. #5
    Join Date
    Jun 2004
    Posts
    3
    ah, very nice thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •