On Fri, 11 Feb 2005 18:41:38 -0500, wrote:
zzapper wrote:
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM;
insert into test values('Some Text\nand some more');
update test set txt = replace(txt,'\n','');
What about the following?
mysql create table test (txt varchar(255)) Type=MyISAM;
Query OK, 0 rows affected (0.00 sec)
mysql insert into test values('Some Text\0and some more');
Query OK, 1 row affected (0.00 sec)
mysql select * from test;
*** 1. row
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM;
insert into test values('Some Text\nand some more');
update test set txt = replace(txt,'\n','');
BTW
\n = null
\0 seems to be something else
Turns out my rotten
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM;
insert into test values('Some Text\nand some more');
update test set txt = replace(txt,'\n','');
BTW
\n = null
\0 seems to be something else
Turns out my rotten
zzapper wrote:
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM;
insert into test values('Some Text\nand some more');
update test set txt = replace(txt,'\n','');
BTW
\n = null
\0 seems to be something else
Turns out my
Hi,
I've successfully used the following update-replace statement to replace
strings in mysql data
update tbl_county_lookup set countyname=replace(countyname,'amp;','and') ;
However I've had problems trying to replace a null character 0x00h ,
I'd be interested to know the syntax to filter
On Thu, 10 Feb 2005 10:17:00 +, wrote:
Hi,
I've successfully used the following update-replace statement to replace
strings in mysql data
update tbl_county_lookup set countyname=replace(countyname,'amp;','and') ;
However I've had problems trying to replace a null character 0x00h ,
I'd