I would like to remove the character '�' from column
Column Name:
asds�dfgdfg
dfgwer�werwer
And Want to replace it with space
Column Name:
asds dfgdfg
dfgwer werwer
Syntax: SELECT SUBSTRING(column_name,2,length(column_name)) FROM table_name; To delete the first character from the FIRSTNAME column from the geeks for geeks table.
That is a Unicode replacement character. If this character is appearing in your table then it might be that you are issuing queries using the wrong character set. You should check the column character set, and you should also check the character set(s) of the connection(s) you use to issue queries. If there is a difference in connection character set between connections used to read and record data, or if there is a difference in expected character set between applications/scripts used to access the data, that would explain the presence of these characters.
If you just want to replace it with a space:
UPDATE myTable SET myColumn = REPLACE(myColumn, '�', ' ')
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With