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 insensitive select * from table where f1 ~* 'cool'; Steve -- thorNET - Internet Consultancy, Services & Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
- Re: [GENERAL] Sql query with partial matching Brett W. McCoy
- Steve Heaven