Reputation: 116207
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
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
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
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
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
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
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
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