AWS Databases EC2 MySQL Wordpress

From Hostgator shared hosting to AWS EC2 using Bitnami’s WordPress AMI

I needed to move two WordPress sites from a Hostgator shared hosting account to AWS EC2 for two simple reasons: website performance and SSL certificates. There are several WP plugins to ease the transfer but the main problem is that the entire website + database is almost 1GB in size so I have to do […]

Databases MySQL

Remove leading and trailing spaces from a string in MySQL

It might be frustrating when trying to query for a record that, without knowing, has a leading or trailing space on a string column. Lets say that you have a User record with ‘ ‘ as email attribute, one easy way to find this record is using the TRIM string function in MySQL: SELECT * FROM […]