Is there any way, when searching through a database to have the place where the object searched is found displayed?
eg. Someone is searching the word "truth" in my database. Say this is found in a line, "The truth is that the end is near." Instead of having that entire line returned, can I make it so that only "...truth is that..." or something to that extent?
I know that their is a LEFT() function to limit the characters result, however if this searched query is found in the middle of 12 paragraphs, how can I narrow down the displayed result?
eg. Someone is searching the word "truth" in my database. Say this is found in a line, "The truth is that the end is near." Instead of having that entire line returned, can I make it so that only "...truth is that..." or something to that extent?
I know that their is a LEFT() function to limit the characters result, however if this searched query is found in the middle of 12 paragraphs, how can I narrow down the displayed result?