Mailing List Archive


Back to the month index Back to the list index
bob basques (bob.basques@stpaul.gov)
Tue, 08 Apr 1997 15:25:09 -0500 

Message-Id: <334AA9A5.2128@stpaul.gov>
Date: Tue, 08 Apr 1997 15:25:09 -0500
From: bob basques <bob.basques@stpaul.gov>
Subject: Re: [mSQL] (B5) Data ranges in Lite?

Graeme Merrall wrote:
>
> Hi.
> Still plugging away on getting my database to a useable form. :)
>
> Is it possible (possibly using LIKE and variants) to display a range of
> data, specifically int's?
>
> What I mean is;
> SELECT price FROM mydata WHERE price < 3400 AND price is > 4000

closer to this:

SELECT price FROM mydata WHERE price < 3400 AND price > 4000

this should also work (2.0b4):

SELECT price FROM mydata WHERE (price < 3400) AND (price > 4000)

>
> or something like that.
>
> Is it even possible in PHP/Perl? I know you could fudge it if you sucked
> in all the records but with the potential for the database to have
> thousands of records, things could get ugly.
>
> Cheers,

bobb 

-- 
Bob Basques
bob.basques@stpaul.gov - WORK
 blammo@win.bright.net - HOME
        www.stpaul.gov - 3rd of a bunch of (Volunteer) Webmasters 
    bridges.stpaul.gov - Webmaster
25 W. 4th St.            PHONE (612)266-6188
900 C.H.A. Bridge Div.     FAX (612)292-6315
St. Paul, Mn. 55102
--------------------------------------------------------------------------
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!