Question

How to show that each MySQL enumeration has an index value?

Answer 1

$\huge \mathbb{Answer}$
______________✉
___________✉

▶The != operator most certainly does exist! It is an alias for the standard <> operator.

Perhaps your fields are not actually empty strings, but instead NULL?

To compare to NULL you can use IS NULL or IS NOT NULL or the null safe equals operator <=>.