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):
1 2 |
select field1,field2 from my_table where field1 similar to '[[:<:]]myword[[:>:]]' |