I would like to know how I can get a single result from a table that is like a phrase.
My table has all the postcodes like so...
and if someone enters say B1 2AB or WC1A 1AB that I wish to find the single result that is like the one entered and obtain the other details in the results.
What query could I use to do this.
My table looks like this...
CREATE TABLE IF NOT EXISTS `postcodes` (
`Pcode` text NOT NULL,
`Grid_N` int(11) NOT NULL DEFAULT '0' COMMENT 'used',
`Grid_E` int(11) NOT NULL DEFAULT '0' COMMENT 'used',