Results 1 to 4 of 4

Thread: How to lower the string case in MySQL?

  1. #1
    Join Date
    Apr 2008
    Posts
    55

    How to lower the string case in MySQL?

    Hi,

    I am searching for a MySQL command that will enable me to lower the String str to lower case automatically for the string. is it possible to lower the case of the string with the help of a command or script?


    Thanks in advance.
    giorgos

  2. #2
    Join Date
    May 2008
    Posts
    29

    Re: How to lower the string case in MySQL?

    You need to learn the string functions.

    LOWER(str): To lowercase

    Code:
    mysql>
    mysql> SELECT LOWER('ABC');
    +--------------+
    | LOWER('ABC') |
    +--------------+
    | abc          |
    +--------------+
    1 row in set (0.00 sec)
    Hope this helps you.

  3. #3
    Join Date
    May 2008
    Posts
    26

    Re: How to lower the string case in MySQL?

    LOWER(str)

    The LOWER(str) function return the String str. And in this String all the characters are changed in the lowercase.

    Code:
    mysql> SELECT LOWER('INDIA');
    ->'india'

  4. #4
    Join Date
    May 2008
    Posts
    35

    Re: How to lower the string case in MySQL?

    For complete list of String Functions please vist.

    1. http://www.roseindia.net/mysql/mysql...function.shtml

    and

    2. http://dev.mysql.com/doc/refman/5.0/...functions.html

    I hope this helps you.

Similar Threads

  1. Opening the plastic flap in lower case of HTC One S
    By Esmond Ivers in forum Portable Devices
    Replies: 2
    Last Post: 18-04-2012, 04:55 PM
  2. Mac server begins with lower case
    By Susquehannock in forum Networking & Security
    Replies: 6
    Last Post: 03-06-2010, 12:22 AM
  3. Replies: 4
    Last Post: 30-01-2010, 07:23 PM
  4. PHP to lower case
    By Berth in forum Software Development
    Replies: 3
    Last Post: 24-09-2009, 02:22 PM
  5. String Concatenation in mySQL
    By JPGargoyle in forum Software Development
    Replies: 2
    Last Post: 18-05-2009, 10:38 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,701,259.76978 seconds with 17 queries