bmql select best options when fields can be blank

Summary:

wondering if there is a way to find best record option when 3 of the fields can be blank meaning any input

Content (required):

we have a table that we use a large WHERE clause where 3 of the fields ar:

(Filed1 = X OR Field1 = NULL) AND (Filed2 = X OR Field2 = NULL) AND (Filed3 = X OR Field3 = NULL)

this might return 2 records

Field 1 = X Field2 Null Filed3 Null

Feld 1 Null Field2 Null Filed3 Null

so we would want the best selection where 1 of the fields was a match, or if for example 2 of the fields matched we would want that one...