$10 for 1 MySQL Line

When exporting my database from an old host, my database content got filled with this set of characters, "Â"

I tried to fix it myself, but got my query quite badly wrong...

So, $10 via PayPal to whoever sends me the line that will search the database and delete all instances of the "Â" (Including the comma).

Thanks.

 

mysql_query("DELETE FROM table_name WHERE column_name='Â'");

Don't know, lol. I don't understand your question. Change the charset perhaps? How about I do it manually?

 

if you send me a copy of the database file, i can check it out...

why not just open it in notepad and do a find/replace?

 

UPDATE column_name SET column_name=REPLACE(column_name,'Â','');

 

Thanks for the replies everyone. NoobieDoobieDo has offered to do it by hand, so I went with him incase I break things again.

Sorry to the others, but thanks anyway.


Tarpon - Good idea, but the database is about 60MB. Last time I tried a find/replace, my whole computer crashed.

 

oK BRO,PM ME NOW WITH MORE DETAILS AND I WILL DO IT FOR YOU..

 

update test set col1 = replace(col1, "Ã,", "");


replace col1 by fieldname from table

replace test by tablename

if more that one fields hv this use this query many times by just changing field names

Regards

Alex

 

I will do this work for you.

Here is it
UPDATE `table_name` SET field_name=replace(field_name,’search_text’,'replace_text’);

Thanks