I want to make a query which select like two seperate words in a column. For example, My datas like this;
Paul Allen Paul Smith Allen John Allen Paul George Allen
I want to select words which contains "Paul Allen". Like this;
Paul Allen Paul Smith Allen Paul George Allen
When I use "like", result is just Paul Allen. When I use "similar to" '%(Paul|Allen)%' result is: all datas. I don't want to these. Thanks...