Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2014
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. CREATE TABLE `jobs` (
  2. `id` INT(8) NOT NULL AUTO_INCREMENT,
  3. `job_id` VARCHAR(50) NOT NULL DEFAULT '',
  4. `title` VARCHAR(255) NOT NULL DEFAULT '',
  5. `company` VARCHAR(255) NOT NULL DEFAULT '',
  6. `city` VARCHAR(50) NOT NULL DEFAULT '',
  7. `state` VARCHAR(50) NOT NULL DEFAULT '',
  8. PRIMARY KEY (`id`),
  9. UNIQUE INDEX `job_id` (`job_id`),
  10. FULLTEXT INDEX `search` (`title`, `company`, `city`, `state`)
  11. )
  12. COLLATE='utf8_general_ci'
  13. ENGINE=MyISAM
  14.  
  15. SELECT id, title, company, state, city FROM `jobs` WHERE MATCH (title, company, state, city) AGAINST ('software engineer in san fransisco california') LIMIT 0,10
  16.  
  17. id;select_type;table;type ;possible_keys;key ;key_len;ref;rows;Extra
  18. 1 ;SIMPLE ;jobs ;fulltext;search ;search;0 ;N ;1 ;Using where
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement