Re: query optimization with CONCAT query

2002-11-05 Thread Andy Ingham
Actually, I'm not convinced it would, because I want to be able to find a string that is *NOT fully contained* within any given field. In other words, I want a search for The catcher in% to match the row: +-+--+ | article | tit

Re: query optimization with CONCAT query

2002-11-05 Thread olinux
Mysql 4.0.1+ supports searches IN BOOLEAN MODE So if mysql 4 is an option, I think that would work for you. http://www.mysql.com/doc/en/Fulltext_Search.html olinux --- Andy Ingham <[EMAIL PROTECTED]> wrote: > Folks -- > > We have built a table with bibliographic information > that contains a