开发者

do I need to use full text search for domain names and Ip address?

I do have domain names and ip address of it. this is almost 200k so when I redesign a table do I need to e开发者_如何学编程nable FULL TEXT SEARCH functionality of MySQL??

I want search table with domain names and IP address as well. means I search by domain then it should show IP address and if I search with IP then it should show domain names.


That depends a bit on your data structure. If you have separate columns with domain names and IP addresses, this is not useful: just search for strings (or partial strings, with LIKE). If you have a large body of text (in a single column/field) which also includes domain names and IP addresses, then FULL TEXT SEARCH may be useful.


No, you don't need to use full text search and you don't need to enable FULL TEXT SEARCH.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜