Hi. using MYSql 3.28
I have a surname column with a standard index and this is the column
were search are performed on, currently the filed only has the one name
i.e.:
Surname: smith
I want to include other column data in the search i.e. fathersname, so I
create an index on that column and in my search I
use a statement like: ....surname = '"& globsurname & "' or fathersname
= '"& globsurname & "'
this does work but tends to slow the thing down,
So Can I take the name from fathersname and include it in the Surname
field so I have say:
Surname: smith jones
It does not seem to work for me, maybe I need a particular separator ?
I want to go this way as each record my have several names that I want
to be able to search on.
Thanks in advance
Regards
John Berman
