Guest User

Untitled

a guest
Apr 23rd, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. mysql> create table content (
  2. -> cid INT auto_increment not null primary key,
  3. -> title varchar(200),
  4. -> description varchar(500),
  5. -> body text,
  6. -> fulltext (title,description,body)
  7. -> ) engine=MyISAM;
  8. Query OK, 0 rows affected (0.01 sec)
  9.  
  10. mysql> insert into content (title,description,body) values ('Business Plan','Here we will describe how to write your proposal','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque sagittis, dui ac lobortis rutrum, arcu ante convallis lorem, vel tempus erat nibh at nunc. Nunc lacinia mattis enim dictum bibendum. Cras quam felis, accumsan sed ultrices at, pretium eget est. Ut pulvinar suscipit metus, ac tempor quam semper eget. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.');
  11. Query OK, 1 row affected (0.00 sec)
  12.  
  13. mysql> select * from content where match (title,description,body) against ('plan');
  14. Empty set (0.00 sec)
Add Comment
Please, Sign In to add comment