I have 290 records in the database with backslashes. I want to remove the backslashes. Why the query below doesn't remove backslashes?
update name set first_name = REPLACE(first_name,'\\\\','') where first_name like '%\\\\%';
I have 290 records in the database with backslashes. I want to remove the backslashes. Why the query below doesn't remove backslashes?
update name set first_name = REPLACE(first_name,'\\\\','') where first_name like '%\\\\%';