Postgres Pro
Downloads
Home   >   mailing lists

SV: How to match percent sybmol in LIKE operator? - Mailing list pgsql-general

From Jarmo Paavilainen
Subject SV: How to match percent sybmol in LIKE operator?
Date
Msg-id 009701c07f09$0ece2cc0$1501a8c0@comder.private
Whole thread Raw
In response to How to match percent sybmol in LIKE operator?  (Sergey Filatov <fs@ibis.odessa.ua>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: libpq++
Next
From: Fred Yankowski
Date:
Subject: Re: Creating a database