L PROTECTED]>
To: "Shaun" <[EMAIL PROTECTED]>
Cc: "PHP DB" <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 10:32 AM
Subject: Re: [PHP-DB] Brick Codes
> SELECT *
> FROM Locations L, Brick B
> WHERE (LEFT(L.'Post Code', LOCATE('
ou whant you can search the mysql string
functions documentation in:
http://www.mysql.com/documentation/mysql/bychapter/manual_Functions.html#Str
ing_functions
- Original Message -
From: "Shaun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 1
t;[EMAIL PROTECTED]>
> To: "Shaun" <[EMAIL PROTECTED]>
> Cc: "PHP DB" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 17, 2004 10:23
> Subject: Re: [PHP-DB] Brick Codes
>
>
> > That may depend of what database server you are using, for mysql yo
"Shaun" <[EMAIL PROTECTED]>
Cc: "PHP DB" <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 10:23
Subject: Re: [PHP-DB] Brick Codes
> That may depend of what database server you are using, for mysql you can
> use:
>
> WHERE (LEFT('B
-
From: "Shaun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 10:04 AM
Subject: Re: [PHP-DB] Brick Codes
> Thanks for your reply,
>
> but what I actually need to do is compare the first 3 or 4 digits of the
> postcode stored
you are using, for mysql you can
> use:
>
> WHERE (LEFT('Brick',3) = LEFT(Post Code,3))
>
> If you are using other dbserver, check your manual.
>
> - Original Message -
> From: "Shaun" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTE
CTED]>
Sent: Monday, February 16, 2004 10:45 PM
Subject: [PHP-DB] Brick Codes
> Hi,
>
> I have a table of Locations around the country. My system produces reports
> based on these Locations. I also have a table containing Brick Codes e.g.
>
> BrickPost Code
> AB51AB5
Hi,
I have a table of Locations around the country. My system produces reports
based on these Locations. I also have a table containing Brick Codes e.g.
BrickPost Code
AB51AB51
AB52AB52
AB55AB55
AB56AB56
AL01AL1
AL02AL2
AL03AL3
AL04AL4
How can I compare the f
