Re: Replace, Substitute, Delete

[John Kebbel]

Instead of individual replacements, as in ...

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

would this global approach work?

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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]