Replace spaces UPDATE `table` SET `col_name` = REPLACE(`col_name`, ' ', '') Remove all tabs characters UPDATE `table` SET `...

Today few clients complained about their websites not working in Google Chrome. It seems to be an issue caused by a recent EasyA...

This will do the magic: //start HTML Minifier function sanitize_output($html) { $search = array( '/\>[^\S ]+/s...

Find: SELECT id, mailing FROM directory_list a JOIN email_temp b ON a.email=b.email; Update: UPDATE directory_list...

Find duplicates: SELECT email FROM directory_list GROUP BY email HAVING COUNT(email) >1; Select all but ignore duplicates: S...

In cPanel WHM EasyApache3 or EasyApache4, you can add GZIP compression server-wide, including new accounts, by adding the followin...