Why don't you use Fulltext indexes, they are very fast and you use several columns.
http://dev.mysql.com/doc/mysql/en/fulltext-search.html Best regards Alejandro -----Mensaje original----- De: nick [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 14 de Marzo de 2005 05:59 p.m. Para: Mysql List Asunto: Re: Multi-Table Query Problem... On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote > Because, with the '%keyword%' operator, you're going to match any of > those columns that contain the keyword inside of it. This can be a > little confusing as 'ef' will return true on 'abcdefghijk'? Instead, > you might try 'keyword%' so that 'apple' returns true for 'apples', > 'apple juice', 'apple cider', BUT returns false for 'ple'. > > But, without seeing the results and what you'd hoped them to be, it's > tough to narrow down the problem. > > sk Yes, I understand, but that's not what I'm getting. I'm getting rows returned where "apples" is not present in any of the columns in any way. I think it's a syntax mistake in my query, but I can't see it. Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
