Jump to content

SELECT 9 BETWEEN 1 AND 0


chameleon_95

Recommended Posts

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:1:afaf82b48c]<?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)\";

?>[/php:1:afaf82b48c]

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.

 

I have been trying to solve this for some weeks now.

 

Thank You.

 

:oops:

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.