ur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 5:27 PM
To: mysql@lists.mysql.com
Subject: RE: Using replace on columns containing *
Hi J.R.
Thanks for your response, but this did not help. If I try the same syntax on
other values (not '*') I have no problem...
-Original Me
nal Message-
From: Eitan Gur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 9:07 AM
To: mysql@lists.mysql.com
Subject: Using replace on columns containing *
Hi all
I have a column in a table containing strings with the '*' character. I'm
trying to use the RE
mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 9:07 AM
To: mysql@lists.mysql.com
Subject: Using replace on columns containing *
Hi all
I have a column in a table containing strings with the '*' character. I'm
trying to use the REPLACE command on this column:
SELEC
Hi all
I have a column in a table containing strings with the '*' character. I'm
trying to use the REPLACE command on this column:
SELECT REPLACE (deviceId, '*', '.*') FROM MY_TABLE;
But I get the following error:
ERROR 1270 (HY000): Illegal mix of collations (utf8_bin,IMPLICIT),
(latin
