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]
