blob: 958883e5841bfd1263f2dab7234211d9efdb0de1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
DROP TABLE IF EXISTS logs;
SET NAMES UTF8;
CREATE TABLE logs(
message TEXT,
FULLTEXT KEY (message)
) DEFAULT CHARSET=utf8;
INSERT INTO logs VALUES("Error Error Error");
INSERT INTO logs VALUES("Warning Warning Warning");
INSERT INTO logs VALUES("Error Error");
INSERT INTO logs VALUES("Warning Warning");
INSERT INTO logs VALUES("Error");
INSERT INTO logs VALUES("Warning");
INSERT INTO logs VALUES("Error Error Error Error");
INSERT INTO logs VALUES("Warning Warning Warning Warning");
SELECT * FROM logs;
message
Error Error Error
Warning Warning Warning
Error Error
Warning Warning
Error
Warning
Error Error Error Error
Warning Warning Warning Warning
SELECT *, MATCH(message) AGAINST("Error" IN NATURAL LANGUAGE MODE) AS score
FROM logs
WHERE MATCH(message) AGAINST("Error Warning" IN NATURAL LANGUAGE MODE)
ORDER BY MATCH(message) AGAINST("Error" IN NATURAL LANGUAGE MODE);
message score
Error 174763
Error Error 349526
Error Error Error 524289
Error Error Error Error 699052
DROP TABLE logs;
|
