can I enable fulltext searching after installing SQL?

Answer 1

Note I am copying and pasting from MySQL Website But the links below cover it in other DBMS.

MySQL has support for full-text indexing and searching:

* A full-text index in MySQL is an index of type FULLTEXT.
* Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.
* A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE INDEX.
* For large datasets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index.

An Example:

mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO articles (title,body) VALUES
-> ('MySQL Tutorial','DBMS stands for DataBase ...'),
-> ('How To Use MySQL Well','After you went through a ...'),
-> ('Optimizing MySQL','In this tutorial we will show ...'),
-> ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
-> ('MySQL vs. YourSQL','In the following database comparison ...'),
-> ('MySQL Security','When configured properly, MySQL ...');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM articles
-> WHERE MATCH (title,body) AGAINST ('database');
+----+-------------------+------------------------------------------+
| id | title | body |
+----+-------------------+------------------------------------------+
| 5 | MySQL vs. YourSQL | In the following database comparison ... |
| 1 | MySQL Tutorial | DBMS stands for DataBase ... |
+----+-------------------+------------------------------------------+
2 rows in set (0.00 sec)


MYSQL
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

POSTGRESQL
http://techdocs.postgresql.org/techdocs/fulltextindexing.php

ORACLE
http://www.oracle-base.com/articles/9i/FullTextIndexingUsingOracleText9i.php

Good Luck

Answer 2

you want the MSDE (Microsoft personal computer Engine) sq. Server 2000 setting up. in case you want the sq. 2005 software for XP, you would possibly want to get the "coach version". XP isn't a server OS, so Microsoft made a pair particular variations of sq. Server.

Answer 3

If it is Oracle, you can use Oracle text, for more info',

http://download-west.oracle.com/docs/cd/B10501_01/text.920/a96517/cdefault.htm#1006068

Answer 4

it depends on which database you are using, if you are using MySQL and MyISAM databases, they support full text. innoDB and other engines don't.