Mailing List Archive


Back to the month index Back to the list index
Graeme Merrall (a.hacker@clear.net.nz)
Tue, 08 Apr 1997 15:14:20 +1200 

Message-Id: <3.0.32.19970408151415.0068c5cc@pop.clear.net.nz>
Date: Tue, 08 Apr 1997 15:14:20 +1200
From: Graeme Merrall <a.hacker@clear.net.nz>
Subject: [mSQL] (B5) Data ranges in Lite?

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
--------------------------------------------------------------------------
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!