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[[:>:]]'
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[[:>:]]'
Join the discussion on Discord, ask a question or share your experience.
Discuss on Discord