Quote:
Originally Posted by trevius
I prefer to use a gui for all MySQL stuff, so having to open the accounts table to find the account ID in it, then checking the new account_ip table for the account ID and entries for it is just 1 extra step.
|
select a.*, b.name from account_ip a, account b where b.id = a.accid;
looking for someone's ip's:
select a.name, b.* from account a, account_ip b where a.name = "Rogean" and b.accid = a.id;