Mailing List Archive


Back to the month index Back to the list index
Justin Subert (Justin.Subert@ccpress.co.uk)
Wed, 09 Apr 1997 09:49:35 +0100 

Message-Id: <334B581F.4EA@ccpress.co.uk>
Date: Wed, 09 Apr 1997 09:49:35 +0100
From: Justin Subert <Justin.Subert@ccpress.co.uk>
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
>
> 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,
> Graeme

Hello,

I'm not sure if I can help, but I did notice an error in your query. The
condition would never be satisfied. If you want prices between 3400 and
4000 the query should read:

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

I hope this helps,

Justin. 

-- 
Without Prejudice
Justin Subert, Systems Manager, Commercial Colour Press Plc
http://www.ccpress.co.uk/~jgs
Justin.Subert@ccpress.co.uk
--------------------------------------------------------------------------
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!