At 14:58 07/12/00 -0500, 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 table where f1 ~ 'cool';
or case i
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
