So, I realized that for my db column values, I have a whitespace in front of all strings.
(Couldn't figure out why
WHERE name = "Sean"
WHERE name = " Sean"
WHERE ltrim(name) = "Sean"
Link to documentation: http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_ltrim
EDIT: Re-read and saw your edit, and noticed you wanted to update. In which case you'd want to run this for each column which has leading whitespace. Here is an example using a dummy table name, and your name column:
UPDATE table SET name = ltrim(name)
That will update every row and remove any leading whitespace.