Thomas Owens
Thomas Owens

Reputation: 116207

Is there a MySQL command to convert a string to lowercase?

I have a MySQL database of keywords that are presently mixed-case. However, I want to convert them all to lowercase. Is there an easy command to do this, either using MySQL or MySQL and PHP?

Upvotes: 131

Views: 105918

Answers (9)

HD FrenchFeast
HD FrenchFeast

Reputation: 1

Interesting to note that the field name is renamed and if you reference it in a function, you will not get its value unless you give him an alias (that can be its own name)

Example: I use a function to dynamically get a field name value:

function ColBuilder ($field_name) {
…
While ($result = DB_fetch_array($PricesResult)) {
$result[$field_name]
}
…
}

my query being: SELECT LOWER(itemID), … etc..

needed to be changed to: SELECT LOWER(itemID) as itemID, … etc..

Upvotes: 0

Vi8L
Vi8L

Reputation: 988

Simply use:

UPDATE `tablename` SET `colnameone`=LOWER(`colnameone`);  

or

UPDATE `tablename` SET `colnameone`=LCASE(`colnameone`);

Both functions will work the same.

Upvotes: 6

uma
uma

Reputation: 2972

use LOWER function to convert data or string in lower case.

select LOWER(username) from users;

or

select * from users where LOWER(username) = 'vrishbh';

Upvotes: -3

dmanxiii
dmanxiii

Reputation: 52153

You can use the functions LOWER() or LCASE().

These can be used both on columns or string literals. e.g.

SELECT LOWER(column_name) FROM table a;

or

SELECT column_name FROM table a where column = LOWER('STRING')

LCASE() can be substituted for LOWER() in both examples.

Upvotes: 9

Rodent43
Rodent43

Reputation: 161

I believe in php you can use

strtolower() 

so you could make a php to read all the entries in the table then use that command to print them back as lower case

Upvotes: -6

Jon Grant
Jon Grant

Reputation: 11520

Yes, the function is LOWER() or LCASE() (they both do the same thing).

For example:

select LOWER(keyword) from my_table

Upvotes: 29

myplacedk
myplacedk

Reputation: 1564

Did you try looking it up? Google, manual...

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_lower

mysql> SELECT LOWER('QUADRATICALLY');
        -> 'quadratically'

Upvotes: 5

Paul Dixon
Paul Dixon

Reputation: 301135

UPDATE table SET colname=LOWER(colname);

Upvotes: 263

Greg
Greg

Reputation: 321864

SELECT LOWER(foo) AS foo FROM bar

Upvotes: 13

Related Questions