in mysql:
select 'a' = 'a ';
return 1
You're not the first to find this frustrating. In this case, use LIKE for literal string comparison:
LIKE
SELECT 'a' LIKE 'a '; //returns 0
548k questions
547k answers
4 comments
86.3k users