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