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]