Google Sheet: Filtering multiple values in a single cell

Question

I'm trying to filter a column and the result should contain both the word "biology" and "aqa".

I'm using this formula now:

=regexmatch(A:A, "biology|aqa"

But the result also contains words that have biology or aqa only like:

My expected result should have both "biology" and "aqa" only like:

user_5632629 · Answer

you are using | which is OR logic. but you need AND logic

=FILTER(A:A, REGEXMATCH(A:A, "aqa"), REGEXMATCH(A:A, "biology"))