Do you know, that… ?

W SOLIDWORKS 2023 there was the possibility of advanced search in the BOM list of materials.

In order to search in a given column, press the symbol as below and specify the search phrase.

You can use custom filters and define conditional advanced selection criteria.