search query in mysql

1SELECT * FROM `articles` where (description LIKE '%how to make%')

1SELECT * FROM table_name WHERE MATCH(col1, col2)
2AGAINST('search terms' IN NATURAL LANGUAGE MODE)
3
4

1mysql> CREATE TABLE tutorial (
2id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
3title VARCHAR(200), 
4description TEXT, 
5FULLTEXT(title,description)
6) ENGINE=InnoDB;
7Query OK, 0 rows affected (2.40 sec)