Posted by on June 28, 2011

Sometimes when we add & within a category, the static url will show “___”, it is not so good, if there are too many we will cost a lot of time to modify them. We can update “___” to “_and_” from PHPmyadmin. Following the next 2 steps: First step: UPDATE pld_category SET TITLE_URL = REPLACE(TITLE_URL, “___”, “_and_”) UPDATE pld_category SET CACHE_URL = REPLACE(CACHE_URL, “___”, “_and_”) The above 2 mysql senstences will update “___” to “_and_”; Second step: UPDATE pld_category SET TITLE_URL = REPLACE(TITLE_URL, “__”, “_”) UPDATE pld_category SET CACHE_URL = REPLACE(CACHE_URL, “__”, “_”) The above 2 mysql senstences will update “__” to “_”;

Posted in: Mysql