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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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.
>
> 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.
>
>
> 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/[EMAIL PROTECTED]
