Creating a PHP script to search through a MySQL database and display the results, is a fairly simple task. Using the MySQL LIKE and NOT LIKE operands, we can find specific values within our database tables.
MySQL gives us the ability to search for terms exactly as they are entered or close to what is entered by using the percentage % or the underscore _ character.