[RESOLVED] Selecting first part of postcode MySQL

[BIOSTALL]

Hi all,

I have a database of London postcodes.

They are in the format:

xx xxx, xxx xxx or xxxx xxx

I need to select the first part of the postcode (ie. up to the space)

Can someone please advise me on how this can be accomplished??

Many thanks,

BIOSTALL

[robert_w_ark]

That was a fast resolution 🙂 See -- Using your brain does accomplish something... ;D

[interface]

Lol !

[offtopic]
if(u cn rd ths) u cn gt a gd jb n cmptr prgrmming;

Most humans can easily read/understand sentences without e's, a's etc.
S yr syng tht mst hmns cn prgrm ? i thnk nt 😉
[/offtopic]