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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
