fulltext_left_join.result 731 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
CREATE TABLE t1 (
id           VARCHAR(255) NOT NULL PRIMARY KEY,
sujet        VARCHAR(255),
motsclefs    TEXT,
texte        MEDIUMTEXT,
FULLTEXT(sujet, motsclefs, texte)
);
INSERT INTO t1 VALUES('123','toto','essai','test');
INSERT INTO t1 VALUES('456','droit','penal','lawyer');
INSERT INTO t1 VALUES('789','aaaaa','bbbbb','cccccc');
CREATE TABLE t2 (
id         VARCHAR(255) NOT NULL,
author     VARCHAR(255) NOT NULL
);
INSERT INTO t2 VALUES('123', 'moi');
INSERT INTO t2 VALUES('123', 'lui');
INSERT INTO t2 VALUES('456', 'lui');
select match(t1.texte,t1.sujet,t1.motsclefs) against('droit')
from t1 left join t2 on t2.id=t1.id;
20 21 22
match(t1.texte,t1.sujet,t1.motsclefs) against('droit')
0
0
23
0.67003107070923
24
0
25
drop table t1, t2;