Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `jobs` (
- `id` INT(8) NOT NULL AUTO_INCREMENT,
- `job_id` VARCHAR(50) NOT NULL DEFAULT '',
- `title` VARCHAR(255) NOT NULL DEFAULT '',
- `company` VARCHAR(255) NOT NULL DEFAULT '',
- `city` VARCHAR(50) NOT NULL DEFAULT '',
- `state` VARCHAR(50) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- UNIQUE INDEX `job_id` (`job_id`),
- FULLTEXT INDEX `search` (`title`, `company`, `city`, `state`)
- )
- COLLATE='utf8_general_ci'
- ENGINE=MyISAM
- SELECT id, title, company, state, city FROM `jobs` WHERE MATCH (title, company, state, city) AGAINST ('software engineer in san fransisco california') LIMIT 0,10
- id;select_type;table;type ;possible_keys;key ;key_len;ref;rows;Extra
- 1 ;SIMPLE ;jobs ;fulltext;search ;search;0 ;N ;1 ;Using where
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement