vendredi 3 avril 2015

Sqlite query to get search word with adjacent words too

I wants to get adjacent words too from a query including the searched word, is it possible to get? or should I go with any other way?


eg., For the below sentence (description column in database table, column name is DESC)


"One of the most popular methods".


select DESC from TABLE_NAME where DESC like 'popular';


Here I want two adjacent words also "most" and "methods". from above text.


I have try to check with REGEXP but not working like



@"SELECT Desc FROM tablename WHERE LineText REGEXP '(^| )popular( |$)'"


Can we get those with query or with other regular expression?


Please suggest. Thanks.


Aucun commentaire:

Enregistrer un commentaire