Expression Filters Help

[Thurpan]

I am trying to filter for blind vs blind hands. So every situation where it folds to the SB

One way of doing this i thought would be when the SB is the first to put money in the pot using tourney_hand_summary.str_actors_p LIKE '9%'
However this doesn't include when the SB gives BB a walk which I need it to and I don't know the thing for that.
Thanks

[Flag_Hippo]

To include walks you can use this expression:

Code: Select all

tourney_hand_summary.str_actors_p SIMILAR TO '9%|'

[Thurpan]

To include walks you can use this expression:

Code: Select all

tourney_hand_summary.str_actors_p SIMILAR TO '9%|'

Thankyou for this. Is there a resource I can use in the future to find stuff like this?

[Flag_Hippo]

What I posted is effectively a short version of:

Code: Select all

tourney_hand_summary.str_actors_p LIKE '9%' OR tourney_hand_summary.str_actors_p LIKE ''

For more detail on pattern matching in PostgreSQL see this guide.