` Printed Icetips Article

Icetips Article

SQL Related Articles: Replacing characters in columns
2004-01-29 -- Rick Martin

Newsgroups: softvelocity.clarion.databasedrivers

>Maybe a bit off the Clarion topic, but I had a situation where I
>wanted to do an update on a mysql table and on one column, replace
>certain characters (replace + with a space).
>
>It looked logical to do something like:
>
>Update mytable
> set mycolumn = select Replace(mycolumn, '+',' ')
>
>But it didn't like that.  After messing with this a bit, I decided to
>write a little process in Clarion to take care of this.  But I'm
>curious how this could be accomplished directly in SQL just for future
>reference.  Anyone have ideas?

Hi Arnor,

I don't know if MYSQL syntax is different than MSSQ, but this works for me.
Update Engineer Set Name = Replace(Name,'Martin','Martini')

I don't think you need the 'Select' part in your example.

HTH,

Rick Martin
Sharpe Software, Inc

Printed November 23, 2024, 5:34 am
This article has been viewed/printed 35211 times.
Google search has resulted in 44 hits on this article since January 25, 2004.