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