如何在MySQL的varchar字段的开头和结尾处删除选项卡? [英] How to remove tabs at start and end of varchar field in MySQL?

问题描述

我在mysql数据库中有一个字段，该字段是varchar(255).我已经看过trim()来删除前导和尾随空格，但它似乎只能处理空格，而不能处理制表符:

I've got a field in a mysql db that's a varchar(255). I've looked at trim() to remove leading and trailing whitespace, but it seems to only handle spaces, not tab characters:

 UPDATE mytable SET textfield = TRIM(textfield);

有人知道如何也删除字段开头和结尾的制表符吗?

Does anyone know how to also strip tabs off the start and end of a field?

推荐答案

您仍然可以使用

You can still use the TRIM function, and specify the character to be trimmed:

UPDATE mytable SET email = TRIM(CHAR(9) FROM TRIM(email));

这篇关于如何在MySQL的varchar字段的开头和结尾处删除选项卡?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！