如何从SQL查询中修剪特殊字符？

Question

trim() is used to clear all the whitespaces. Now, instead of clearing white spaces, I want to eleminate all special characters from the 'username'. Is there any function like trim() for eliminating special characters?? My sql query is like

Select value from table_name where trim(username) = 'ABCD'

and it returns null value. But there are some values related to 'ABCD' and it displays all the entries when i execute the query

select value from table_name where username like '%ABCD%'

there are nothing else like visible in 'username' field. Is there any solution for this?

Answer 1

Mysql does not have such kind of functionality to remove special characters. Instead you can use replace function (if you know what are special characters).

replace(your filed name,'_','')