query optimization with CONCAT query

2002-11-05 Thread Andy Ingham
Folks -- We have built a table with bibliographic information that contains a field for initial articles and for titles (sans initial articles). Some sample data (with all other fields suppressed): +-+--+ | article | title

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

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 |