UPDATE userfield SET field2 = REPLACE(field2, ' ', '_') WHERE field2 LIKE '% %;
I'm going to run in on a copied db. I just need to make sure it works as I'll have to do it right before doing my final import. I'm going to be using the Big Board Importer, which is why I have to do this. The standard importer doesn't require this step.
Thanks in advance.