wild-card search in postgres

Question

Is there a way for me to search using wild-card % in Postgres to only retain the searches that have non-zero replacement of %? So %a% should only result in cab but not a. If not with %, is there another simple way to do so? Thanks!

Use _ instead of %.

cachique
– cachique

2017-06-22 20:47:29 +00:00
Commented Jun 22, 2017 at 20:47 — cachique
– cachique, Commented Jun 22, 2017 at 20:47

cachique · Accepted Answer · 2017-06-22 21:57:58Z

2

From the manual

An underscore (_) in pattern stands for (matches) any single character; a percent sign (%) matches any sequence of zero or more characters.

You need to use _ instead of %

Edited
Final expression as suggested by @Abelisto should be '%_a_%'

edited Jun 22, 2017 at 21:57

answered Jun 22, 2017 at 20:52

cachique

1,2811 gold badge13 silver badges19 bronze badges

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

1 Comment

Abelisto Over a year ago

I think "non-zero" (one or more) means %_a_%

Collectives™ on Stack Overflow

wild-card search in postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related