MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tablename (c1 varchar(100));

insert into tablename values(null), (''), ('N/A'), ('x')

select NULLIF(NULLIF(c1, ''), 'N/A') from tablename;