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. Take a look at 6.3.2 String Functions and you will find a range of facilities that will allow you to achieve this (and much more)! Regards, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
