forum.lissyara.su

CREATE TABLE site_graduate(
  id INT(11) NOT NULL AUTO_INCREMENT,
  fio VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (id),
  FULLTEXT INDEX fio (fio)
)
ENGINE = MYISAM
AUTO_INCREMENT = 1375
AVG_ROW_LENGTH = 91
CHARACTER SET cp1251
COLLATE cp1251_bin;

SELECT id, MATCH (fio) AGAINST ('искомый текст') as reletiv FROM site_graduate order by reletiv DESC;

=======================================================================================================
| id | reletiv |
=======================================================================================================
| 689 | 0,0 |
-------------------------------------------------------------------------------------------------------
| 690 | 0,0 |
-------------------------------------------------------------------------------------------------------
| 691 | 0,0 |
-------------------------------------------------------------------------------------------------------
| 692 | 0,0 |