Hi
My host used mysql v3.23.28 and I use ASP for data access on my
genealogical database
I have created a fulltext index on 3 fields, surname,groomsurname and
bride surname
And I retrieve an exact name using the following:
SQL = "SELECT * FROM global WHERE MATCH (SURNAME, GROOMSURNAME,
BRIDESURNAME) AGAINST (' "& globsurname & " ') "
With globsurname coming from my search form - this works fine for an
exact match
Can I use pattern matching against the text collection along the lines
of
SQL = "SELECT * FROM global WHERE MATCH (SURNAME, GROOMSURNAME,
BRIDESURNAME) Like (' "& globsurname & "% ') "
So it will pick all those rows starting with say A or B, I have spent
hours playing with the syntax so I hope its possible ?
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
