We have an application that needs to index every word (token) in a name, separately.
Ex: "New York" must be indexed under "New" and "York". One solution is to create an auxiliary table, extract the tokens one word at a time, and cross-reference to the key of the original table. Ex: CREATE TABLE places ( idp INT(8) NOT NULL, place CHAR(32), /* Ex: "New York" */ PRIMARY KEY(idp) ) CREATE TABLE tokens ( idt INT(8) NOT NULL AUTO_INCREMENT, token CHAR(32), /* Ex: "New" OR "York" */ idp INT(8) /* refers to same key in 'places' */ PRIMARY KEY (idt), INDEX (token) ) Is there a faster/more elegant way to do this? 'FULLTEXT' is not suitable. (Please forgive my naïveté, I am new to MySQL). --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php