Computers are fascinating!
TIL 'a'='a ' is true in standards compliant SQL.
Turns out, if the strings are different lengths, one is padded with spaces before comparing them.
Was super confusing at first when RIGHT(Comment, 1)='; ' was finding results!