How to find in postgres strings like %'%

Question

I need to search in my column strings which contains '

select * from app_user au where au.last_name like '%'%'

but something like that gives me

SQL Error [42601]: Unterminated string literal started at position 55

I tried also '%\'%', but it's not working too, how to escape ' in postgres?

Does this answer your question? Replace apostrophe in string Insert text with single quotes in PostgreSQL Postgresql escape single quote in where clause — Bergi
– Bergi, Commented Jul 3, 2023 at 10:55

Mukul Bindal · Accepted Answer · 2023-07-03 10:53:59Z

0

To escape ', you need to add it twice. Use '' to resolve it.

select * from app_user au where au.last_name like '%''%'

answered Jul 3, 2023 at 10:53

Mukul Bindal

4332 silver badges17 bronze badges

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

1 Comment

Bergi Over a year ago

@nbk the game ?

nbk · Accepted Answer · 2023-07-03 10:51:58Z

0

You need to double the single quote to get the result

CREATE TABLE app_user (last_name text)

INSERT INTO app_user VALUES ('ma''affee')

select * from app_user au where au.last_name like '%''%'

last_name
ma'affee

fiddle

As you see in the sample the INSERT needs also a double single quote, but prepare statements with parameters will take the need to double single quote away when inserting or selecting

answered Jul 3, 2023 at 10:51

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Collectives™ on Stack Overflow

How to find in postgres strings like %'%

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related