Update a field with a / 1

[proximity]

Hi,

I am moving from ACCESS to mySQL 5.1 and I am trying to convert some of my queries. Most of it was not too painless, but this one is driving me crackers!

I have a table with some numbers in it of the type VARCHAR(8). Now, the numbers going into this table have seven digits:
1234567
1234425
8514256

etc.

What I want to do is update these numbers so that after the third number a / is inserted, thus (which is why the field type is VARCHAR!)

123/4567
123/4425
851/4256

etc.

I'm hoping this will be super easy!! Any help, as ever, gratefully received.

--
Steven

 

[feherke]

Hi

[b]update[/b] your_table [b]set[/b] your_field[teal]=[/teal]insert[teal]([/teal]your_field[teal],[/teal][purple]4[/purple][teal],[/teal][purple]0[/purple][teal],[/teal][green][i]'/'[/i][/green][teal]);[/teal]

Feherke.

http://free.rootshell.be/~feherke/

 

[proximity]

Hi feherke,

Many thanks for your help, feherke - it works brilliantly!

--
Steven