What do these % symbols mean?
Those are wildcards for pattern matching. To quote the docs www.postgresql.org/docs/current/static/functions-matching.html#FUNCTIONS-LIKE <www.postgresql.org/docs/current/static/functions-matching.html#FUNCTIONS-LIKE> :
‘abc’ LIKE ‘abc’ true
‘abc’ LIKE ‘a%’ true
‘abc’ LIKE ‘_b_’ true
‘abc’ LIKE ‘c’ false
> On Feb 1, 2018, at 14:37, Das Goravani <email@example.com> wrote:
> It’s a field in a WHERE clause from one of the demo apps. I understand the brackets and quotes but have not seen the percent symbols used in this way.
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:firstname.lastname@example.org