I am trying to create a query that searches for key words in text fields for
a web based helpdesk application. Currently I am using the like operator
but if I do a search on problems with ACT (a contact management app) if will
find all cases with those letters in the history. Example below:
Select * from cases where case_history like '%ACT%'
Finds the word ACT but also contact, actor, contractor, and so on. I do
need it to find words like updates if the user types update or printing if
the user types printer. Also the above query only finds words that are
grouped together, so if the user types ACT printing problem, if will only
find cases that have that exact phrase instead of just the three keywords.
Any help would be greatly appriciated