On Wed, 1 Mar 2006, Price, Randall wrote:
} Try the following:
}
} REPLACE(products_description, CHAR(9), " ")
Thanks, Randall, that did it. And I feel quite stupid, as well, because I
re-checked my two test entries [33 and 37] and both had had their tabs
removed at some point. So it turns out
Try the following:
REPLACE(products_description, CHAR(9), " ")
Randall Price
VT.SETI.IAD.MIG:Microsoft Implementation Group
http://vtmig.vt.edu
[EMAIL PROTECTED]
-Original Message-
From: Vince LaMonica [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 01, 2006 10:44 AM
To: mysql@lists.
On Wed, 1 Mar 2006, Vince LaMonica wrote:
} update products_description set products_description =
} replace(`products_description`,'\t',' ') where products_id = "37";
[snip]
I should have also stated that in the above example, both the table name
and the column name are the same - that's not a
On Wed, 1 Mar 2006 [EMAIL PROTECTED] wrote:
} [snip]
} Does anyone have any suggestions? The mysql server [and client] are
} running under Linux. The products_description field is a 'text' type. If
}
} there's further info you need, please let me know.
} [/snip]
}
} Are you using REPLACE(column
[snip]
Does anyone have any suggestions? The mysql server [and client] are
running under Linux. The products_description field is a 'text' type. If
there's further info you need, please let me know.
[/snip]
Are you using REPLACE(column_name, '\t', ' ') ?
--
MySQL General Mailing List
For list a
