PostgreSQL Match any strings

Question

I have a SQL query:

select recipe_title
             from recipe where
             meal_type ='BREAKFAST'

Is it possible to match any meal_type by only change the BREAKFAST?

Such as:
    select recipe_title
                 from recipe where
                 meal_type = *

I know I can use like %% but that will need to change many places in my code. Is it possible to get all meal_type and still use =

Thanks!

Is the ? in the question a placeholder or just that you want use the = operator? Can you expand how this is being used in your code? — user3783243
– user3783243, Commented May 29, 2020 at 0:31

AdamKG · Accepted Answer · 2020-05-29 00:39:58Z

2

No. = is an equality operator. The best you can do is WHERE meal_type = ANY('{BREAKFAST,LUNCH,DINNER}'), iff you have a known short list of all possible values, but there's no wildcard-like behavior with =. The correct way of doing this (returning all rows regardless of meal_type) is to not have a meal_type = <whatever> in your WHERE clause.

answered May 29, 2020 at 0:39

AdamKG

14.1k3 gold badges41 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL Match any strings

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related