[websmart]

MySQL Query:My records will write UserId in all rows. When retrieving records
is there any command like (as in foxpro/dbase) 'SET FILTER TO
UserId=NNN' so that all commands will be executed only on records
having UserId set NNN only ? or will I have to write like 'Select * from
myTable where amount>5000 and UserId=NNN' in every type of query ?


Thanks for help

[Andy1984]

im fairly new to mysql and still learning but wouldnt this help

PHP Code:

$query = "SELECT * FROM myTable WHERE UserId like 'NNN%'"; 

the position of the % means somthing, not quite sure but i think if your userid was tedNNN then the % should be at the start, %NNN

then again i could be totaly wrong

[infinitylimit]

% in sql is a wildcard same with * but they are used differently. Andy is correct in thinking that %bar would return foobar, datebar, candybar while bar% would return barnone, bark, barbque,

% in php is a modulus operator that gives you a remainder

like 5 % 3 = 2 which is like saying 5/3 what is the remainder

anyway my 2c

[websmart]

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.