August 14, 2006 12:40 PM Subscribe
MySQL refuses to index my table properly, because the data I'm looking for is only three letters long.
posted by reklaw to computers & internet (16 answers total) 1 user marked this as a favorite
I wrote a little database postcode app, and wondered for ages why it wasn't working properly. Then I realised it would return results perfectly well when I searched for a four-character postcode, like BA16 -- it was just ignoring the three-character ones, like BA5. Is there any way to turn off (or work around) this idiotic MySQL behaviour?
If it matters, I'm using fulltext indexes with this SQL:
SELECT * FROM 'pc' WHERE MATCH (town,county,postcodes,area,county) AGAINST ('BA5').