I want to implement a "word only" search in sqlite.
My first option seems to be [charlist] that select words that are surrounded by [space, tab, point, comma, punctuation, etc]. Something like this: SELECT ... WHERE 'name' LIKE "%[ \t.,!?]word[ \t.,!?]%"
However I cannot find a way to add space/tab to [charlist]. Is this possible ?
What is "the best way" to implement a "word only" search in sql ?
Aucun commentaire:
Enregistrer un commentaire