Administer > Database administration > Data persistence > Queries > Use the like relational operator

Use the like relational operator

Applies to User Roles:

System Administrator

Example: Retrieve all contact records that contain the letter e as the second letter of the last name.

In this example, we execute a like query where the field is like ?e* and then displays a record list containing all matching records.

To use the like relational operator:

  1. Click System Administration > Base System Configuration > Contacts.
  2. Type ?e* in the Full Name field.
  3. Press Enter.
  4. Click any record to view the details.

Note: This query contains two wildcard characters, which triggers Database Manager to automatically generate a like query. A like query does not automatically generate a starts with query. For example, to see all records that start with any character followed by e* with any number of characters following, type ?e\** in the field. The returned records include those where the is like Ae*, he*e, fe*, Be*bcdefg, and so on.

Related topics

Like relational operator
Record retrieval
Relational operators
Wildcard characters
Retrieving records by using the record list method
The Database Manager utility

Retrieve all records in a table
Retrieve records within a range