I have some weird stuff going on in my data imports. I find myself getting some trailnig white space, which then messes up my URLs as I base them on two field, category and subcategory.
I hjave various routines to clean them, eg
//Clean category
mysql_query("UPDATE main2006 SET category=replace(category, '\(', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '\)', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '&', 'and')");
mysql_query("UPDATE main2006 SET category=replace(category, '\/', ' ')");
mysql_query("UPDATE main2006 SET category=replace(category, '\'', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '\.', ' ')");
mysql_query("UPDATE main2006 SET category=replace(category, '\(', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '\)', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '\'', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '&', 'and')");
mysql_query("UPDATE main2006 SET category=replace(category, '+', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '?', '')");
mysql_query("UPDATE main2006 SET category=replace(category, '-', ' ')");
Sometime I get spaces at the end of the field.
Is there a query or method to remove white space, if it present at the end of a field?
Or do I have to strip them out oe by one with php, remove and then insert back in?
Any ideas.
Cheers