Re: Sql query with partial matching

On Thu, 7 Dec 2000, Travis Bauer wrote:

> 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."

SELECT * FROM mytable WHERE f1 LIKE '%cool%';

or use a regular expression:

SELECT * FROM mytable WHERE f1 ~* 'cool';

http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
"Pascal is Pascal is Pascal is dog meat."
-- M. Devine and P. Larson, Computer Science 340