Hi, I'm Ahmad. I make websites with Joomla!

Welcome, Feel free to navigate my website and I will be glad to hear from you.

WIN A FREE COPY OF "Mastering Joomla! 1.5 Extension and Framework Development"

Recommended Book

0523_Mastering_Joomla_1

Find more freelance jobs

What's going on twitter

12
Jul
2010
MySQL Search and Replace PDF Print E-mail

MySQLSearching and replacing text in your database is easy using the SQL command:

     UPDATE table SET field = REPLACE (field,'pattern','whatever');

I've always used this command to remove styles and colors inserted into the contents by the WYSIWYG editors by my clients. You can execute this command through phpMyAdmin from your hosting panel or if you're stuck without it you can always use one of the database management tool for Joomla! Art Adminer is great and it will let you access other databases on the same server too!