MySQL自动转换为小写 [英] MySQL automatic conversion on lowercase

问题描述

我有多个在数据库表内写入数据的Web服务. 我想针对特定字段将大写字符串自动转换为小写字符串. 有执行该任务的mysql函数吗?

I have multiple web services that write data inside a database table. I'd like to automatic convert uppercase strings into lowercase ones, for a specific field. Is there any mysql function that performs this task?

假设这是表格:

id | name | language

有时，Web服务在language字段内编写一个大写字符串(IT). 我想直接在MySQL内部将其转换为小写字符串("it").

Sometimes, inside the language field, web services write an uppercase string (IT). I want to convert it into a lowercase string ("it"), directly inside MySQL.

谢谢

推荐答案

在表上定义触发器 :

CREATE TRIGGER lcase_insert BEFORE INSERT ON my_table FOR EACH ROW
SET NEW.language = LOWER(NEW.language);

CREATE TRIGGER lcase_update BEFORE UPDATE ON my_table FOR EACH ROW
SET NEW.language = LOWER(NEW.language);

然后更新现有数据:

UPDATE my_table SET language = LOWER(language);

这篇关于MySQL自动转换为小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！