Search a string to find which records in table are inside said string
- by Improfane
Hello,
Say I have a string.
Then I have a number of unique tokens or keywords, potentially a large number in a database.
I want to search and find out which of these database strings are inside the string I provide (and get the IDs of them).
Is there a way of using a query to search the provided string or must it be taken to application space?
Am I right in thinking that this is not a 'full text search'?
Would the best method be to insert it into the database to make it a full text search?