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
RE: Using replace on columns containing *
Part of the problem is that you have a ' ' in between your REPLACE and your
(). The REPLACE function needs to have that space removed.
SELECT REPLACE(deviceID,'*','.*') FROM MY_TABLE;
Try that and see if it helps.
J.R.
-Origi
Part of the problem is that you have a ' ' in between your REPLACE and your
(). The REPLACE function needs to have that space removed.
SELECT REPLACE(deviceID,'*','.*') FROM MY_TABLE;
Try that and see if it helps.
J.R.
-Original Message-
From: Eitan Gur [mailto:[EMAIL PROTECTED]
Sent:
