it builds a fulltext index? I am using version 4.0.18.
I would like to treat a "." as part of a word, rather than as a separator character.
Ideally, I would like to set this for just one index of one table.
I have a large table with many text fields. My UI allows users to enter a simple
string which is matched against all appropriate fields in the table. Since MySQL
uses at most one index per table, and doesn't use them at all for 'like' queries,
this was very slow. So I built a new table with an index column and a text
column, fulltext-indexed. The text column contains all of the fields from the
original table concatenated together, space-separated.
Retrieval is now very fast, but I cannot match against embedded URLs since the "." is taken as a word separator. I suppose I could turn all of the "." characters into something else on the way in, and then back on the way out, but that smells funny.
Any ideas?
Jeff;
-- * RSS Feeds: http://www.syndic8.com * Resume: http://www.syndic8.com/~jeff/resume.html * MSN IM: [EMAIL PROTECTED] * Developer Books: http://www.developer-books.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
