function to replace a substring into a string

[Matth_S]

Hi,

I would like to update a table ; I have a field "name" in which I would like to remove all part of only 1 char length.

I explain :
If I have a name such as "part1 o part2" , after update I want to get "part1 part2".

As I didn't find how to do this update only using mysql functions, I use a php page with the following execution :

1/ I select the name field
2/ I use the function explode to get each word
3/ I use the function strlen to get the length of each word
4/ I rebuild the string with the words of more than 1 chr length
5/ I update the field.

It's really slow !

Do you know any other way to do this update ? Is there a(some) mysql function(s) that I can use ?

[laserlight]

You could cut down the time for steps 2 to 4 with a single [man]preg_replace/man, but then the database operations will still be expensive.