More on Index's

["John Berman" <suppressed>]

Well I have leaned a lot on creating an index and then using it to
search - I do however get strange results sometimes in my names dbase

This is my index info

FULLTEXT KEY `surnamei`
(`SURNAME`,`GROOMSURNAME`,`BRIDESURNAME`,`OTHERSURNAME`,`MOTHERMNAME`)
) TYPE=MyISAM COMMENT='Surname Index'


My SQL is:

SQL = "SELECT * FROM global  WHERE MATCH (SURNAME, GROOMSURNAME,
BRIDESURNAME, OTHERSURNAME, MOTHERMNAME) AGAINST ('"& globsurname & "')"

Works well for most queries if I search on cohen it brings back rows
that don't contain cohen - how can that be, other names work fine

My index is fulltext is this the right type of index for an exact match
on a name , when I try to create a normal or unique Index I  get the
error message "specified key is to long: Max key length is 500"

Regards


John Berman




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php