I just realized, I think that indices may not avail you when you're doing a search based on double-sided wildcards.
I'm afraid you may be forcing a full table-scan by performing that kind of search. So run a few benchmark tests. Maybe populate a test database with a large volume (like 100,000 rows or more) so you'll notice performance differences, and then run a few tests. Cheers, -Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]