A program I use has SQL & RTF files to generate reports and I'm wanting to remove all instances of the - (minus) symbol from the resulting document. I'd tried a SELECT REPLACE but I'm not very ...
I hope I worded the question right. Here are the specifics: This is regarding a MySQL database. I've inherited several hundred posts with custom fields and a unique excerpt. At this point I think I ...
I have a few variable data in the column "email". For example: email@example.com firstname.lastname@example.org How do I get rid of the characters after .com? I used Replace(email,'.com%',gmail.com), ...