MySql and REPLACE

[geogal]

Hi All,

I've looked up the MySQl function of Replace, but am a bit puzzled. I have a results page that can be downloaded to a .txt file. Once downloaded, the file is then imported into ACT! for client use. The problem is that in the comments field, hard returns are screwing up the import. ACT! thinks this is a new record.

I've fixed the problem with PHP for future input, but how can I go into MySql and replace all occurrence of hard returns already there? According to the mysql web site, you cannot use primary key fields? This got 0 results:

---

UPDATE contact SET comments = REPLACE(comments, "\n", " ") WHERE id=319

---

Any help is deeply appreciated!

Geogal

[trooper]

Your syntax is wrong it as follows

SELECT REPLACE(in_string,old_string,new_string);

That will now work

HTH

GM

[geogal]

Thanks Trooper, for the fast response! Is there a place in that query to put my table and column name?

Can I do this?

---

SELECT Replace(comments, '\r\n', ' ') FROM contact WHERE ID=319

---

Thanks.

Geogal

[geogal]

Rats, it didn't work. I'm still getting end of line marks in my .txt file. Perhaps I should tackle it from the download portion of my PHP file, rather than within MySql.

---

$query = stripslashes($_POST["query"]); <------ pass via a submit button

$result = mysql_query($query);
header ("Content-Type: application/octet-stream");
header ("Content-Disposition: attachment; filename=\"result.txt\"");

while ($row = mysql_fetch_row ($result))
print (join ("\t", $row) . "\r\n"); <------ HERE???
mysql_free_result ($result);

---