If I filter a BindingSource's column like this: `"column1 LIKE '%John%'"`, then all rows containing John on that column will return.

How to return all rows for which column1 contains `[some text]John[some text]Doe` ?

`"column1 LIKE '%John%Doe'"` does not work.