How To Perform Key Word Search in Tables?
The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as ‘%keyword%’, where (%) represents any number of any characters. Any single quote (‘) in the keyword needs to be protected by replacing them with two single quotes (”).