Mysql – PostgreSQL’s and MySQL’s full text search

full-text-searchmysqlpostgresqlsearch

How do the full text search systems of PostgreSQL and MySQL compare? Is any clearly better than the oder? In which way are they different?

Best Solution

PostgreSQL 8.3 has built in full text search which is an integrated version of the "tsearch2"

Here is the documentation: http://www.postgresql.org/docs/8.3/static/textsearch.html

And the example from the documentation:

SELECT title
FROM pgweb
WHERE to_tsvector(body) @@ to_tsquery('friend');

Where body is a text field. You can index specifically for these types of searches and of course they can become more complex than this simple example. The functionality is very solid and worth diving into as you make your decision.

Best of luck.

Related Solutions

Unix – Use grep –exclude/–include syntax to not grep through certain files

Use the shell globbing syntax:

grep pattern -r --include=\*.cpp --include=\*.h rootdir

The syntax for --exclude is identical.

Note that the star is escaped with a backslash to prevent it from being expanded by the shell (quoting it, such as --include="*.cpp", would work just as well). Otherwise, if you had any files in the current working directory that matched the pattern, the command line would expand to something like grep pattern -r --include=foo.cpp --include=bar.cpp rootdir, which would only search files named foo.cpp and bar.cpp, which is quite likely not what you wanted.

Update 2021-03-04

I've edited the original answer to remove the use of brace expansion, which is a feature provided by several shells such as Bash and zsh to simplify patterns like this; but note that brace expansion is not POSIX shell-compliant.

The original example was:

grep pattern -r --include=\*.{cpp,h} rootdir

to search through all .cpp and .h files rooted in the directory rootdir.

Vim clear last search highlighting

To turn off highlighting until the next search:

:noh

Or turn off highlighting completely:

set nohlsearch

Or, to toggle it:

set hlsearch!

nnoremap <F3> :set hlsearch!<CR>

Best Solution

Related Solutions

Unix – Use grep –exclude/–include syntax to not grep through certain files

Vim clear last search highlighting

Related Question