Advanced search add option for "Not an Empty Field"

[dreamingdigital]

Can there be another option added to the Admin side advanced search for "Not an Empty Field" please?

advanced-search-options.PNG

... and if there is an equiv that works right now can somebody please tell me?
EX: "Not Like" and an empty field going along with it is not the answer. I've tested some of this stuff.

[Brennan]

Hi Colin -

You should be able to use the Contains option and then for the value put an underscore. This is wildcard in mysql for any character.

• The percentage ( % ) wildcard matches any string of zero or more characters.
• The underscore ( _ ) wildcard matches any single character.

[William Davis]

Hi Colin -

You should be able to use the Contains option and then for the value put an underscore. This is wildcard in mysql for any character.

• The percentage ( % ) wildcard matches any string of zero or more characters.
• The underscore ( _ ) wildcard matches any single character.

Wow, learn something new every day. It might be a good idea to include that tip somewhere within the application as a tool tip.

While on this subject, how does Advance Search "* (Comma Separated List)" works? I've never been able to make it work.