Author: rocker8942

MySQL: remove special character from DB field

UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘<‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘>’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘”‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘%’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘;’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘(‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘)’,… Continue reading MySQL: remove special character from DB field

Quick ways to check SEO friendliness of website

Useful web to make a report on SEO readiness. 1. http://www.woorank.com/ Free for one report only for a week. For this reason, I’ll move over to the alternative that’s ‘grader’. 2. http://marketing.grader.com/ Free for unlimited sites. Good thing about these is the report is including advices to how to improve the SEO friendliness. 3. http://www.google.com/analytics/ Basic of… Continue reading Quick ways to check SEO friendliness of website

Joomla Extensions you must have

Akeeba Backup – Through and easy backup tool. The first extension you might install. KCE – Powerful WISIWIG Editor K2 – Powerful article component which is enough to replace default article Send Joomla Updates to Twitter, Facebook and More