Searching in the Users module
|Top Previous Next|
The Users module includes a Search tool that enables you to run a search for items in your list of users. You can launch this tool by clicking the magnifying glass icon (See Figure 299 below).
The search tool, which would then appear right above the list of users (see Figure 300 below), contains the following elements:
The SQL LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
There are two wildcards often used in conjunction with the LIKE operator:
% - The percent sign represents zero, one, or multiple characters
_ - The underscore represents a single character
%a - Finds values that end with 'a'.
a% - Finds values that start with 'a'.
_a% - Finds values with 'a' in second position.
Searches are case-sensitive
Click the magnifying glass icon to run the search.