Searching Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 149

Print View
We see the Print view and Print view (with full texts) links on the results page. These
links produce a more formal report of the results (without the navigation interface)
directly to the printer. In our case, using Print view would produce the following:

This report contains information about the server, database, time of generation,
version of phpMyAdmin, version of MySQL, and SQL query used. The other link,
Print view (with full texts) would print the contents of TEXT fields in its entirety.

Wildcard Searching Searching

Let's assume we are looking for something less precise: all topics with 'cinema' in
their title. First, we go back to the search page. For this type of search, we will use
SQL's LIKE operator. This operator accepts wildcard characters: the % character
(which matches any number of characters) and the underscore ( _ ) character (which
matches a single character). Thus we can use %cinema% to let phpMyAdmin
find any substring that matches the word 'cinema'. If we left out both wildcard
characters, we will get exact matches with only that single word.

Since phpMyAdmin 2.6.0, this substring matching has been made easier to access, by
adding it to the Operator drop-down list. We only have to enter the word cinema and
use the operator LIKE %...% to perform that match. We should avoid using this form
of the LIKE operator on big tables (thousands of rows), because MySQL does not use
an index for data retrieval in this case, leading to wait time that could add up to half
an hour (or more). This is why this operator is not the default one in the drop-down
list, even though this method of searching is commonly used on smaller tables.