Update and backslashes

[mikerh9]

I have 290 records in the database with backslashes. I want to remove the backslashes. Why the query below doesn't update backslashes?

update name set first_name = REPLACE(first_name,'\\','') where first_name like '%\\%';

[Sxooter]

What database program is this?

[mikerh9]

Sxooter wrote:

What database program is this?

mysql 4

[Sxooter]

Does anyone else know if \ is an escape character for MySQL like it is for PostgreSQL? I'm guessing that's what's biting our friend here.

[csn]

Yeah, I think it is, IIRC. I'd guess only two backslashes are needed:

update name set first_name = REPLACE(first_name,'\','') where first_name like '%\%';