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[[:>:]]'

Questions or comments?

Join the discussion on Discord, ask a question or share your experience.

Discuss on Discord
  1. zabbix_statsLinux : Monitoring And supervision with Zabbix
  2. PostgreSQL: backup script for all databases