mysql - 将 %keyword% 转换为匹配(反对)

Question

select col1,col2,col3,col4,col5 from table1
where (col1 like '%keyword%' 
       or col2 like '%keyword%' 
       or col3 like '%keyword%' 
       or col4 like '%keyword%' 
       or col5 like '%keyword%' )
AND start_date IS NULL 
AND end_date IS NULL 
ORDER BY date_created limit 10;

我想将上述查询转换为使用 MATCH AGAINST 函数。

Answer 1

我猜你是说某事。像那样？但正如 @Yohanes Khosiawan 所说，您也可以自行查阅文档。

SELECT col1,col2,col3,col4,col5 
FROM table1
WHERE MATCH(col1, col2, col3, col4, col5) AGAINST ('+keyword')
AND start_date IS NULL 
AND end_date IS NULL 
ORDER BY date_created limit 10;