CODEWITHSUNDEEP
postgresqlselectsql-like
Halim
Halim

Reputation: 65

postgresql select like one column two words

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...

Upvotes: 0

Views: 1472

Answers (1)

Vao Tsun
Vao Tsun

Reputation: 51649

To match several words, use more wildcard chars in same pattern. In your case:

like '%Paul%Allen%

Upvotes: 3

Related Questions