iC Home > Know-how > MySQL Database > Access > Fulltext Search
MySQL Database	5.1 Fulltext Search

Your MySQL connection id is 5 to server version: 4.1.8-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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.01 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)

Logical AND's

SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+comparison +root' IN BOOLEAN MODE);

• MySQL.com/doc/mysql/en/fulltext-search.html - Reference
  Full-Text Search Functions
  dev.mysql.com/doc/mysql/en/fulltext-search.html
  
  

<- 5 Access       5.1.1 Fulltext of MySQL sucks ->

copyright by reto - created with mytexi