PostgreSQL - How to use wildcard in string condition

Question

I have a string: A%A

I want to find all string same start with A%A in database.

Example:

AABCD - false
AABCE - false
AA%BC - true

I use the sql statement:

Select * from Tabel where Column like 'AA%B%'

But the result are:

AABCD
AABCE
AA%BC

Because the string include wildcard '%' and postgres select wrong.

Please suggest me a solution

Check this how-to-escape-string-while-matching-pattern-in-postgresql if it helps. — NzGuy
– NzGuy, Commented Oct 20, 2016 at 7:48

0xdead · Accepted Answer · 2016-10-20 08:01:13Z

2

To escape the % char, use \ like this \%

UPDATE

Another approach can be achieved by using the ESCAPE keyword with empty string after it, this way you tell postgres to disable escaping, and the % becomes a normal char

select * from Table where Column like '%' ESCAPE '';

edited Oct 20, 2016 at 8:01

answered Oct 20, 2016 at 7:49

0xdead

14k6 gold badges62 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL - How to use wildcard in string condition

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related