Was reusing syntax from other languages
On a bigint not null field it functioned as I expected, and I didn't consider that a varchar would be completely different. Correct syntax for what I wanted is WHERE name = '' OR name IS NULL.
===
Implicitly condoning stupidity since 2001.