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


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:

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.