how to remove special character in database?

Question

How to convert Banks’ to bank's in db. all records to add Banks’ like this. how can print with Banks’ in screen.

Answer 1

You can use

 SELECT REPLACE('Banks’', 's’', ''\s') from table_name