> > The question is how can I use some sort of statement using
> mysql and php
> > to select all rows between 1 and 0 NOT 0 and 9 like the
> above statement
> > performs.
Sure, an option was nicer, but isn't the following possible?
SELECT ... WHERE ... AND ( x BETWEEN 1 AND 9 OR x BETWEEN 0 AND 1 )
Regards,
TomH
--
PROSOFT EDV-Lösungen GmbH & Co. KG
Geschäftsführer: Axel-Wilhelm Wegmann
AG Regensburg HRA 6608 USt.183/68311
Verwaltung : 93053 Regensburg, Stadlerstraße 13
office : 93049 Regensburg, Ladehofstraße 28
www : http://www.proSoft-Edv.de
email : Tom.Horstmann@stripped
phone : +49 941 / 78 88 7 - 121
fax : +49 941 / 78 88 7 - 20
cellphone : +49 174 / 41 94 97 0
--
> -----Original Message-----
> From: Director General: NEFACOMP [mailto:dg@stripped]
> Sent: Tuesday, October 21, 2003 11:11 AM
> To: Steven Ducat; mysql@stripped
> Subject: Re: SELECT 9 BETWEEN 1 AND 0
>
>
> I am sorry to say that your question is not clear.
> Why don't you send us a simple Table with few data and what
> you want to
> achieve in simple terms? I mean a more clear question!!!
> Have tried using IN().
> In your subject, you said 9 BETWEEN 1AND 0????? I am confused.
>
>
> Thanks
> Emery
> ----- Original Message -----
> From: "Steven Ducat" <steve@stripped>
> To: <mysql@stripped>
> Sent: Tuesday, October 21, 2003 08:12
> Subject: SELECT 9 BETWEEN 1 AND 0
>
>
> > I am trying to create a select query to find the post town
> of a users
> > post code. I am using Royal Mails (UK) post town gazetteer.
> UK Postcode
> > (eg. RH6 9XJ). The first column contains the first half of
> the post code
> > (eg. RH6) and the next column holds the range of the second
> half (eg.
> > 2AA-6PP).
> >
> > I have some code as follows:
> > <?php
> > $pc = explode(" ","RH6 9XJ");
> >
> > "SELECT postTown, postCode, SUBSTRING(postSector,1,3) as a,
> > SUBSTRING(postSector,5,3) as b, postCounty FROM postCode
> WHERE postCode
> > = \"".$pc[0]."\" AND \"".$pc[1]."\" BETWEEN
> SUBSTRING(postSector,1,3)
> > AND SUBSTRING(postSector,5,3)";
> > ?>
> >
> > This will return 1 row for example if the first column was
> "RH6" and the
> > second column was "8ZZ-9ZZ".
> >
> > But in the post town list the range goes from 1 - 0 (eg. 1AA-0ZZ) so
> > what I find is if I use the postcode "RH6 9XJ" and a first
> column of RH6
> > and a second column of 7AA-0BW it will not return the row
> as it does not
> > count from 1 - 0.
> >
> >
> >
> > What I really need is some sort of function where I can set
> the range
> > that the between option sorts from.
> >
> > I have been trying to solve this for some weeks now.
> >
> > Thank You.
> >
> > Steve.
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1 7thweb.de
>
