Navicat Blog

Perform Full-text Searches in MySQL (Part 3)| Navicat Blog Dec 19, 2019 by Robert Gravelle

Welcome to part 3 of this series on full-text indexing and searching in MySQL. In Part 1, we saw how MySQL provides full-text search capability via FULLTEXT indexing along with the three following distinct types of full-text searches:

  • Natural Language Full-Text Searches
  • Boolean Full-Text searches
  • Query expansion searches

In Part 2, I described how to perform Natural Language full-text searches in Navicat for MySQL. Today's blog follows where part 2 left off and covers the next type of full-text searching: Boolean Full-Text searches.

Dec 10, 2019 by Robert Gravelle

November 25 is the official launching date for Navicat Premium 15. Currently, version 15 packs a wallop of new features and improvements, most notably in data transfers, the SQL Builder, and modeling. It also adds Data Visualization, Dark Mode and native Linux support. In today's blog we'll learn how the new Data Visualization feature helps us turn our database into visuals that provide valuable insights into our data through a wide variety of charts and graphs.

Oct 15, 2019 by Robert Gravelle

In Part 1, we saw how MySQL provides full-text search capability via FULLTEXT indexing along with three distinct types of full-text searches. In today's blog, we'll learn how to perform Natural Language full-text searches in Navicat for MySQL.

Oct 11, 2019 by Robert Gravelle

Full-text Search, or FTS, is one of the techniques employed by search engines to find results in their database(s). You too can harness the power of FTS to search for patterns that are too complex for the Like operator. In today's blog, we'll learn how full-text searching is implemented in MySQL. In part 2, we'll try our hand at some queries using Navicat for MySQL as our database client.

Oct 4, 2019 by Robert Gravelle

Navicat Monitor, the agentless database server instance monitoring tool for MySQL and MariaDB recently added support for SQL Server. Hence, it can now monitor database process and system resources for locally hosted SQL Server instances as well as those provided via Amazon Web Services (AWS). Today's blog will provide a quick guide for connecting to an SQL Server instance in order to monitor its performance using Navicat Monitor 2.0.

Navicat Blogs
Feed Entries
Blog Archives
Share