>>>>> "Jochen" == Jochen Daum <[email protected]> writes:
>> The queries are similar to LIKE 'act%'
Jochen> I'm pretty sure they will speed up like 'act%' but not
Jochen> like '%act%'. You may have to restrict the length of the
Jochen> index?
As Jochen says. Length is not an issue.
MysqL full text search is another option.
--
Cheers,
Berend de Boer
--~--~---------~--~----~------------~-------~--~----~
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
-~----------~----~----~----~------~----~------~--~---
