SV: How to match percent sybmol in LIKE operator?

From: "Jarmo Paavilainen" <netletter(at)comder(dot)com>
To: "Sergey Filatov" <fs(at)ibis(dot)odessa(dot)ua>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: SV: How to match percent sybmol in LIKE operator?
Date: 2001-01-15 15:37:24
Message-ID: 009701c07f09$0ece2cc0$1501a8c0@comder.private
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

...
> My problem is to find percent character in some field.
> I'm wonder how specify percent character or other wildcard characters
> in 'LIKE patterns'?

If memory serves: "\%"

That is escape char and percent (in this case backslash).

// Jarmo

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fred Yankowski 2001-01-15 16:31:51 Re: Creating a database
Previous Message Bruce Momjian 2001-01-15 14:32:16 Re: libpq++