Hi Pol,
MySQL support FULLTEXT indexes, and natural language searches, including
Boolean conditions. This may help you; however, you will have to adjust the
default behavior of the index, but changing server settings. By default there
is a minimum word length which you will have to adjust, and a list of stopwords
(words to ignore.) Both of these will prevent you from indexing each and every
word, and even still words that show up in most or all records will be ignored
(and I don't know if you can change that behavior.) The alternative, is using
unindexed lookups, which would be very slow for any non-trivial application.
See:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
The highlighting and switching behavior is up to your application. MySQL just
stores data, it's up to you to write programs that manipulate it.
In all honesty, if this really is a personal application, you may be better
off using another, simpler method.
Regards,
Gavin Towey
-Original Message-
From: news [mailto:n...@ger.gmane.org] On Behalf Of Pol
Sent: Wednesday, August 19, 2009 2:38 AM
To: mysql@lists.mysql.com
Subject: text records and cross referencing
Hi
i am very new to mysql. I am playing around with it to test it as a
personal vocabulary and language expression manager.
Main field would be a passage from a text work, where each word is
searchable.
Any experience and reports about such use?
A further questions is about the possibility to make cross references, that
is
1) highlighting all records that have been connected (by the user) to the
displayed record
2) switching from a record to another one, within the same database.
Thank you
---Pol
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com
The information contained in this transmission may contain privileged and
confidential information. It is intended only for the use of the person(s)
named above. If you are not the intended recipient, you are hereby notified
that any review, dissemination, distribution or duplication of this
communication is strictly prohibited. If you are not the intended recipient,
please contact the sender by reply email and destroy all copies of the original
message.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org