Mailing List Archive


Back to the month index Back to the list index
Kenneth.Holmlund@tp.umu.se
Thu, 19 Sep 1996 23:22:23 METDST 

From: Kenneth.Holmlund@tp.umu.se
Message-Id: <199609192122.XAA26078@minerva.tp.umu.se>
Subject: Re: [mSQL] [w3-mSQL] Search for a substring
Date: Thu, 19 Sep 1996 23:22:23 METDST

> Hello!
>
> 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.
>
> Any help is appreciated...
> Thanx,
> Roberto

You don't say if you need to find it using SQL queries to
msql or internally in w3-msql. In mSQL you do:
SELECT * FROM tablename WHERE fieldname LIKE '%Avenue%'
If you want to do a case insensitive search you would
instead do:
SELECT * FROM tablename WHERE fieldname LIKE '%[aA][vV][eE][nN][uU][eE]%'

If you instead are looking for substrings stored in w3-msql variables
I'm afraid I can't help you.
I use PHP/FI instead (http://www.vex.net/php/) and there you
can both look for substrings and complex regular expressions.
Perhaps you can do that in w3-msql too ? I can't remember..
Kenneth 

--
  _____________________________________
 / Kenneth Holmlund                    \ 
|  Dept. Theoretical Physics            |
|  Umee University                      |
|  S-901 87 Umee                        |
|  Sweden                               |
|  phone: +46-(0)90-167717              |
|  fax:   +46-(0)90-169556              |
|  email: Kenneth.Holmlund@TP.UmU.SE    |
|  web: http://www.tp.umu.se/~holmlund/ |
 \___________________________ _________/
--------------------------------------------------------------------------
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!