You have the
WHERE
clause that you can use with commands such as
LIKE
or
BETWEEN
that you can use to do a filter.
For e.g.
select * from myTable where email like 'ABC.COM'
In addition, wild card characters
[
^] like % and ? provide additional filtering criteria for a query.