exact match find and replace

[Shari]

Hi! I've search and search for a way to create a find and replace for an
exact match via phpmyadmin, and I've not been able to either figure out
how to use what I have found or it only works in mysql itself.

I need to replace a single digit number with a three digit number, but
don't want to replace any other 2 or 3 digit numbers that match the
single digit I'm replacing.

ie: I need to replace "1" with "365", however I don't want to make "132"
"36532".

Thanks for any help or direction on this.

Shari

[Marc Delisle]

Post by Shari
Hi! I've search and search for a way to create a find and replace for an
exact match via phpmyadmin, and I've not been able to either figure out
how to use what I have found or it only works in mysql itself.
I need to replace a single digit number with a three digit number, but
don't want to replace any other 2 or 3 digit numbers that match the
single digit I'm replacing.
ie: I need to replace "1" with "365", however I don't want to make "132"
"36532".
Thanks for any help or direction on this.
Shari

Please ask your question in a MySQL or SQL discussion forum.