Small issue with FULLTEXT searches

2010-04-29 Thread Chris Knipe
Hi List, Table structure: mysql DESCRIBE FlightRoutes; +-++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-++--+-+-+---+ | EntryID | char(36) | NO | PRI | NULL| | | Dep |

Re: Small issue with FULLTEXT searches

2010-04-29 Thread Baron Schwartz
Chris, The index on (Dep, Des) is not a full-text index. If you use SHOW CREATE TABLE, I think this becomes much easier to see at a glance. - Baron On Thu, Apr 29, 2010 at 8:10 AM, Chris Knipe sav...@savage.za.org wrote: Hi List, Table structure: mysql DESCRIBE FlightRoutes;