Re: substring replace

2002-01-24 Thread DL Neil
Hi SF, > Hi, > Please help me to use SQL (with mysql prompt) command to replace any digit > in column. > > Example: > Old value 123466 > New value 123456 > > How to replace old value at fifth digit (6) to 5? You can download the MySQL manual to use it on your own machine, or access it online.

substring replace

2002-01-23 Thread Sommai Fongnamthip
Hi, Please help me to use SQL (with mysql prompt) command to replace any digit in column. Example: Old value 123466 New value 123456 How to replace old value at fifth digit (6) to 5? Thank you, SF ---