Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 04-08-2009
Member
 
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
Reply With Quote
  #2  
Old 04-08-2009
Member
 
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.
Reply With Quote
  #3  
Old 04-08-2009
Member
 
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'
Reply With Quote
  #4  
Old 04-08-2009
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to lower the string case in MySQL?"
Thread Thread Starter Forum Replies Last Post
Opening the plastic flap in lower case of HTC One S Esmond Ivers Portable Devices 2 18-04-2012 04:55 PM
Mac server begins with lower case Susquehannock Networking & Security 6 03-06-2010 12:22 AM
How to compare string using java program regardless of their case? MAGALY Software Development 4 30-01-2010 07:23 PM
PHP to lower case Berth Software Development 3 24-09-2009 02:22 PM
String Concatenation in mySQL JPGargoyle Software Development 2 18-05-2009 10:38 AM


All times are GMT +5.5. The time now is 08:09 PM.