When you include search conditions in EVERY command, it will
work, naturally.
What I meant was, in foxpro/dbase, after you open table and use
'SET FILTER TO CITY="New York"' then you keep on working on
that table and run other commands on that table, only those records
which have city='New York' will be displayed, edited, deleted etc.
In every command you will not be requred to additionally type
FOR CITY='New York' once you have SET filter for that.
For MySQL Table, is similar command exist, which limit subsequent
commands for those type of records only without using record matching
criteria for EACH command.
Hope this makes my question clear.