X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 26B308B9EB6 for ; Sun, 6 Feb 2005 18:21:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41525-02 for ; Sun, 6 Feb 2005 18:21:37 +0000 (GMT) Received: from mxout2.iskon.hr (mxout2.iskon.hr [213.191.128.16]) by svr1.postgresql.org (Postfix) with SMTP id B107D8B9E96 for ; Sun, 6 Feb 2005 18:21:36 +0000 (GMT) Received: (qmail 21901 invoked from network); 6 Feb 2005 19:21:34 +0100 X-Remote-IP: 213.191.142.122 Received: from unknown (HELO mx.iskon.hr) (213.191.142.122) by mxout2.iskon.hr with SMTP; 6 Feb 2005 19:21:34 +0100 Received: (qmail 27346 invoked from network); 6 Feb 2005 19:21:34 +0100 X-Remote-IP: 213.191.138.133 Received: from zg05-132.dialin.iskon.hr (HELO serverd) (213.191.138.133) by mx.iskon.hr with SMTP; 6 Feb 2005 19:21:33 +0100 Message-ID: <001e01c50c78$68eb3120$0600a8c0@serverd> From: "Darko Prenosil" To: "b t" , References: <20050206101246.28648.qmail@web61003.mail.yahoo.com> Subject: Re: How to search for a subString Date: Sun, 6 Feb 2005 19:18:55 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01C50C80.B321EF60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/13 X-Sequence-Number: 5258 This is a multi-part message in MIME format. ------=_NextPart_000_001B_01C50C80.B321EF60 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable You probably did not use correct syntax for LIKE, try with=20 SELECT * FROM movie WHERE name LIKE '%the%fast%'; In the future if You want help from this list, be more specific about = the problem, send some example, error message or such, not just = explanation: "It does not work !" Regards ! ----- Original Message -----=20 From: b t=20 To: pgsql-interfaces@postgresql.org=20 Sent: Sunday, February 06, 2005 11:12 AM Subject: [INTERFACES] How to search for a subString Hi, I'm building a database for a school project and I want to search = for the name of the movie, fro example in the database there is a table = called movie and has a movie call "The fast and the furious" so if the = type in "the fast" then it should return that movie. I tried using like = and ilike and it still would not work. Thanks in advance -BT -------------------------------------------------------------------------= ----- Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' ------=_NextPart_000_001B_01C50C80.B321EF60 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable
You probably did not use correct syntax = for LIKE,=20 try with
SELECT * FROM movie WHERE name LIKE=20 '%the%fast%';
 
In the future if You want help from = this list, be=20 more specific about the problem, send some example, error message or = such, not=20 just explanation: "It does not work !"
 
Regards !
 
----- Original Message -----
From:=20 b t =
To: pgsql-interfaces@postgres= ql.org=20
Sent: Sunday, February 06, 2005 = 11:12=20 AM
Subject: [INTERFACES] How to = search for a=20 subString

Hi, I'm building a database for a school project and I want to = search for=20 the name of the movie,  fro example in the database there is a = table=20 called movie and has a movie call "The fast and the furious" so if the = type in=20 "the fast" then it should return that movie. I tried using like and = ilike and=20 it still would not work.
Thanks in advance
-BT

Do you Yahoo!?
Yahoo! Search presents - Jib=20 Jab's 'Second Term' ------=_NextPart_000_001B_01C50C80.B321EF60--