like below fixes the issue It's impossible, cuz doctrine store array and simple_array data like text. It converted to PHP array after hydration. All possible types and docs. So need to use full-text search, but my table engine is InnoDB.
Doctrine findOneBy simple_array property isn't returning a valid match
fixed the issue. Will look into that further I know the question is quite old, but since I stumbled across the same issue... The SQL Logging was quite helpful. The problem is, that in public_comments a string of comma separated strings is stored in the database. This string has to be found in the array given to the IN keyword. Since in this array the values are separate and not concatenated to a string as in public_comments the IN operator can't find the string.