PostgreSQL: full text search on entire words

Here is a way I found to make full a full text search on entire words only with postgreSQL (tested on v8.1):

SELECT field1,field2 FROM my_table
WHERE field1 SIMILAR TO '[[:<:]]myword[[:>:]]'

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.