Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ARRRG mysql data problem
found the replace statement and cleaned them up, 1422 rows affected and fixed with your help.. You ROCK.... -
ARRRG mysql data problem
I hate to admit this, but I have no clue of how to write the statement to do this. I have several records in the table that have this. Would you terribly mind giving me a hand -
ARRRG mysql data problem
THANK YOU so much.... Looks like it may me a CR As you see below the result for (a) was the email address and the $ was in position 1 of the next line. a gfeeback@comcast.net $ Now I have several of these. Any clue of how to clean them up? Again, thanks mucho -
ARRRG mysql data problem
I have a wierd scenario with some data in my db. I have an email list program that I can enter addresses one at a time or import. For some reason the email entered one at a time are fine, the imported ones have problems. I think there may be hidden data or something in the field. example...
