RE: [PHP-DB] %Like%

<snip> Don't know about the O(n). In Paul Dubois' book, he recommends not using the double %what% unless that's actually what you need. It's got something to do with better optimization if you can use the what% form. </snip> Hey Mike, You're absolutely right. When you do a query using LIKE , if you use the '%foo%' format, MySQL will NOT use any indexes on that column and hence there probably be a slowdown if the server needs to do a full table scan and there's a lot of records to sift through. I actually believe '%foo' also will not use an Indexes. Sincerely, Craig Vincent