Searching a Database
Searching an SQL database is referred to as "selecting" data to view. While you can specify to only see certain columns, for simplicity's sake we will always search each column of the database.
To show every item in our books database, you would write :
SELECT * FROM
In SQL, a '*' is called a wildcard. This is a placeholder that stands for "can be anything." In this case, since we are searching just the '*', we are searching for anything in the database, which is why every record is displayed.
Searching for strings