Mailing List Archive


Back to the month index Back to the list index
Robert Betts (robert@rbit.co.za)
Thu, 19 Sep 1996 20:06:14 +0200 (SAT) 

From: Robert Betts <robert@rbit.co.za>
Message-Id: <199609191806.UAA08417@rbit.co.za>
Subject: Re: [mSQL] [w3-mSQL] Search for a substring
Date: Thu, 19 Sep 1996 20:06:14 +0200 (SAT)

Roberto Cota Rivas wrote:
> I am running version 1.0 of w3-msql on an AIX machine...
> I need to find a substring within a string, for example 'Avenue'
> where all the records with an address string containing 'Avenue' will be
> returned.

Select ....... from table where field like "%substr%" 

-- 
Robert
-----------------------------------------------------------------------------
robert@aztec.co.za               Robert W. Betts
http://www.rbit.co.za/           PO Box 10173, Linton Grange, Port Elizabeth
http://aztec.co.za/              South Africa, 6015
-----------------------------------------------------------------------------
Freedom is an illusion, you only have the choice to what/whom you submit. 
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!