Hi PHPUG, Sorry for the OT post, I have a small problem with a search hinting table taking a long time to perform LIKE queries that you might have experience with.
Would an index on the varchar field speed up the LIKE queries? My understanding of indexes is that they only work for direct select queries, and would only improve a field = value query. The queries are similar to LIKE 'act%' Cheers, Stig --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
