From the menu, Selection > Select By Attributes

To create an expression,

• choose a layer from which you want select features
• double-click the field you want to use
• click an operator
• click Get Unique Values
• double-click the value.

You can combine expressions using AND or OR operators.