Hi All,
say i would like to search for customer, entrying some text
then i would like mysql to return all the customer which id and full name consist of
the text
ex:
ID Name
John01 John The Junior
Abe01 Abe The Senior
Jo01 Johns The Best
if i enter the criteria 'john' i would like the result of John01 and Jo01
if i enter the criteria 'be' i would like the result of Abe01 and Jo01
if i use the fulltext index, then i could only match a full word, eg:
match(id,name) against('John') only resulting the field John01
i can use the clause
where id like '%text%'
or name like '%text%'
but it's wayyy to slow :)
anyone have a better idea.. i appreciate it so much
regards
-leo-
