Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > mysql的全文检索有人会吗？前提是搜索中文。

mysql的全文检索有人会吗？前提是搜索中文。

WBOY
Release： 2016-06-23 13:52:11
Original
806 people have browsed it

网上找了很多资料，
match against 貌似对中文无解，
那么该如何做大数据量搜索呢,
用like的效率据说不行啊？
有人做过吗？
分享点经验吧


回复讨论(解决方案)

我刚下了个dedecms的，搜索模块是like。
一些著名的cms貌似也没好办法？

coreseek(sphinx)+php

有条件的就用第三方插件（如#2）
没条件就分词后存储十六进制内码表示，并使用 FULLTEXT索引

Related labels：
Chinese search Search
source：php.cn
Previous article：php代码问题 Next article：【分享】一种实用的处理表单参数和URL参数的方法，你想到了吗？
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1361
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
How to display only the lowest value from a result set (MYSQL) I have the following statement: selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'...
From 2024-04-06 21:44:19
0
1
603
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template