Re: Fulltext search -- no wildcards in phrases?
On Wed, 2 Apr 2003, Shamit Verma wrote: The replay on the webpage says that: Nope. That would be a really slow search since mysql cant use any indexes and a table scan would be the only way to find it. Then even LIKE operator should suffer from the same performance drawback, how does LIKE operator work with indexes? exactly. LIKE '%something' will not use indexes but LIKE 'some%' will. Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Fulltext search -- no wildcards in phrases?
I once got this answer to a similar question on another group. http://www.mail-archive.com/[EMAIL PROTECTED]/msg00280.html Bernhard - Original Message - From: Nick Arnett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 8:59 PM Subject: Fulltext search -- no wildcards in phrases? It appears to me that fulltext phrase searches cannot include wildcards. For example, I would expect app* serv* to match application server, application services, etc. But it returns no results, so I'm having to run each variation separately. Can anyone confirm that wildcards, indeed, can't be used in phrase searches. I'm doing these in Boolean mode because I need exact counts of occurrences. This is on MySQL-4.0.12-nt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fulltext search -- no wildcards in phrases?
The replay on the webpage says that: Nope. That would be a really slow search since mysql cant use any indexes and a table scan would be the only way to find it. Then even LIKE operator should suffer from the same performance drawback, how does LIKE operator work with indexes? Shamit Verma, http://www.vshamit.com - Original Message - From: Bernhard Döbler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:01 PM Subject: Fw: Fulltext search -- no wildcards in phrases? I once got this answer to a similar question on another group. http://www.mail-archive.com/[EMAIL PROTECTED]/msg00280.html Bernhard - Original Message - From: Nick Arnett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 8:59 PM Subject: Fulltext search -- no wildcards in phrases? It appears to me that fulltext phrase searches cannot include wildcards. For example, I would expect app* serv* to match application server, application services, etc. But it returns no results, so I'm having to run each variation separately. Can anyone confirm that wildcards, indeed, can't be used in phrase searches. I'm doing these in Boolean mode because I need exact counts of occurrences. This is on MySQL-4.0.12-nt. -- 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]
re: Fulltext search -- no wildcards in phrases?
On Thursday 27 March 2003 20:59, Nick Arnett wrote: It appears to me that fulltext phrase searches cannot include wildcards. For example, I would expect app* serv* to match application server, application services, etc. But it returns no results, so I'm having to run each variation separately. Can anyone confirm that wildcards, indeed, can't be used in phrase searches. I'm doing these in Boolean mode because I need exact counts of occurrences. This is on MySQL-4.0.12-nt. Yes, phrase search currently doesn't work with operators. It's still in TODO. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fulltext search -- no wildcards in phrases?
It appears to me that fulltext phrase searches cannot include wildcards. For example, I would expect app* serv* to match application server, application services, etc. But it returns no results, so I'm having to run each variation separately. Can anyone confirm that wildcards, indeed, can't be used in phrase searches. I'm doing these in Boolean mode because I need exact counts of occurrences. This is on MySQL-4.0.12-nt. Nick -- Nick Arnett Phone/fax: (408) 904-7198 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]