Sql query with partial matching

From: Travis Bauer <trbauer(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Sql query with partial matching
Date: 2000-12-07 19:58:13
Message-ID: 20001207145812.A7694@ghost.cs.indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How would I write an sql statement which would select all the
records from a table where some string field contains
some substring? Example: find all the records where f1 contains
the world "cool."

Thanks,

--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Soma Interesting 2000-12-07 20:00:05 multi-byte support
Previous Message Tom Lane 2000-12-07 19:51:30 Oracle-compatible lpad/rpad behavior