Applying a definition query to a feature class using the Add Clause option adds extra apostrophes before and after any commas that may be present within the attribute values.

Workaround

1. Open the Definition Query tab for the feature class again. Click on the 'SQL' button to manually edit the already applied clause.
2. Edit the clause and remove the extra apostrophe (‘) which has been added before and after the comma between 'Hawaii, state' and 'Maine, state'.
3. The clause originally displays: STATE_NAME IN ('Hawaii', 'state', 'Maine', 'state'). Change the SQL query to: STATE_NAME IN ('Hawaii, state', 'Maine, state')
4. The attribute table refreshes and now displays the two records.

Note: There is another workaround in Step 3:

Change the SQL query from:

PROJECT_NAME IN ('Exmouth (Combined Operational Area)', 'Pluto/Brunello (Combined Operational Area)','Scarborough (Combined Operational Area')

to:

PROJECT_NAME IN ('Exmouth (Combined Operational Area)', 'Pluto/Brunello (Combined Operational Area)','Scarborough (Combined Operational Area)')

Steps to Reproduce