Skip site navigation (1) Skip section navigation (2)

Re: LIKE vs =

From: David Wheeler <david(at)kineticode(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: LIKE vs =
Date: 2004-08-23 18:10:46
Message-ID: C1D11C13-F52F-11D8-990D-000A95972D84@kineticode.com (view raw or flat)
Thread:
Lists: sfpug
On Aug 23, 2004, at 10:46 AM, David Fetter wrote:

> Does LIKE when you stick wildcards on the front & back of the
> expression?
>
> SELECT * FROM keyword WHERE name LIKE '%ºÏÇÑÀÇ%';

No:

bric=# select * from keyword where name LIKE '%북한의%';
  id | name | screen_name | sort_name | active
----+------+-------------+-----------+--------
(0 rows)

Regards,

David

In response to

sfpug by date

Next:From: Dror MatalonDate: 2004-08-23 20:13:32
Subject: Re: LIKE vs =
Previous:From: David WheelerDate: 2004-08-23 18:09:45
Subject: Re: LIKE vs =

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group