Instead of individual replacements, as in ...

SELECT REPLACE('De Long', ' ', '');

would this global approach work?

SELECT REPLACE(imgName,' ','') FROM staff WHERE imgName REGEXP ' ';

> Instead of individual replacements, as in ...
>
> SELECT REPLACE('De Long', ' ', '');
>
> would this global approach work?
>
> SELECT REPLACE(imgName,' ','') FROM staff WHERE imgName REGEXP ' ';

I just used that as an example. What you are doing is fine, you put the
field name in the first argument of the REPLACE() function. You no not need
to add the where imgname REGEXP part at all.

SELECT REPLACE(imgName,' ','') FROM staff
That should suffice, unless you have some other limiting factor you want to
toss in like :

SELECT REPLACE(imgName,' ','') FROM staff WHERE imgName LIKE '%d'
You get the idea, that would select all image names that end in 'd'
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.