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

Re: How to search for a subString

From: "Darko Prenosil" <Darko(dot)Prenosil(at)finteh(dot)hr>
To: "b t" <qtboyzz(at)yahoo(dot)com>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: How to search for a subString
Date: 2005-02-06 18:18:55
Message-ID: 001e01c50c78$68eb3120$0600a8c0@serverd (view raw or flat)
Thread:
Lists: pgsql-interfaces
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'

In response to

pgsql-interfaces by date

Next:From: Nick BurchDate: 2005-02-07 14:17:46
Subject: Re: PGXML
Previous:From: Kretschmer AndreasDate: 2005-02-06 15:11:45
Subject: Re: [despammed] How to search for a subString

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