There may be a more elegant way, but this works:

Open finder, and search for ‘foo’. Once the search starts, click the + on the far right

(the lower one :-):

then, on the dropdown on the left scroll down to ‘other’, and in the popup, scroll to ‘Comment’, and select ‘in Menu’:

At this point, you can right click your headings, and add the ‘Comment’ field, and sort by it. You can also do searches where Comment [contains, starts with, etc].

In addition to adding the comments column, you can select ‘Raw Query’ and make more complicated searches like:

kMDItemFinderComment=2020-08* && ......

You can save these searches as ‘Smart Folders’, and refer back to them as needed. See this page for more tips.