CODEWITHSUNDEEP
sqloracle-database
Pit
Pit

Reputation: 49

query for search results with 'like'

I'm looking for a good query string to get better search results.

at the moment I use the operator like

select title from table where lower(column) like '%data%'

but the results are not accurate enough.

My "search engine" is looking for events, news and webcontent on my website, so I want to get results with 'data' as a word like 'Big-Data', 'Big Data.', 'All Data', but no results like 'maxdata', 'bigdata', 'datapool'. Can I use REGEXP_LIKE?

Upvotes: 1

Views: 102

Answers (1)

Egor Skriptunoff
Egor Skriptunoff

Reputation: 23757

select title 
from table 
where regexp_like(column, '(\W|^)data(\W|$)', 'i')

Upvotes: 2

Related Questions