From: Darko Prenosil <Darko.Prenosil@finteh.hr>
To: b t <qtboyzz@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: How to search for a subString
Date: Sun, 6 Feb 2005 19:18:55 +0100
Message-ID: <001e01c50c78$68eb3120$0600a8c0@serverd> (raw)
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
You probably did not use correct syntax for LIKE, try with
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 -----
From: b t
To: pgsql-interfaces@postgresql.org
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'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Darko.Prenosil@finteh.hr, qtboyzz@yahoo.com
Subject: Re: How to search for a subString
In-Reply-To: <001e01c50c78$68eb3120$0600a8c0@serverd>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox