要删除的特殊字符 [英] special characters to be removed

问题描述

大家好，

我有一列包含有特殊字符的数据，所以每当我从该列中读取数据时，我都希望没有特殊字符的数据，即仅显示数字和字母.所以我可以得到任何解决方案来限制sql中的特殊字符吗?

Hi all,

I have a column with data containing special characters , So whenever i read data from this column i want the data without special characters i.e only numbers and alphabets to be shown. So can i get any solution to restrict the special characters in sql???

推荐答案

^ ]

•_任何单个字符.
•[]指定范围([a-f])或集合([abcdef])中的任何单个字符.
•[^]不在指定范围([^ a-f])或设置([^ abcdef])内的任何单个字符.

•_ Any single character.
•[ ] Any single character within the specified range ([a-f]) or set ([abcdef]).
•[^] Any single character not within the specified range ([^a-f]) or set ([^abcdef]).

这篇关于要删除的特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！