Re: How to search for a subString

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(at)postgresql(dot)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'