On 26 Sep, 11:19, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On 26 Sep, 11:08, mcl <mcl.off...@googlemail.com> wrote:
>
>
>
> > I am very new to MySQL and programming and I have some errors in a
> > field in my database
>
> > Field = 'Brian, Bill,Joe, Peter'
>
> > Some fields are missing the space after the 'comma'
>
> > I need to match on any 'comma + character'
> > but not 'comma + space'
> > and replace with 'comma + space + original character'
>
> > There can be more than one error in a field
>
> > so I guess I need something like
>
> > Update mytable set myfield = replace (mytable.myfield, some wonderful
> > regexp)
>
> > Any gratefully appreciated
>
> > Richard
>
> Your problem is that the field violates First Normal Form (1NF).
>
> Normalise your database and this problem will never ooccur.http://del.icio.us/Captain_Paralytic/normalization

Captain,

Thanks for the reply, but I do not know what you mean.

It is a Text field and I want to put a space after every comma where
there is not one for presentation purposes.

Richard