set @com=concat('set @INSTID=(SELECT ID FROM info_instances WHERE hostname like "%' , hostnamein , '%" AND PORT=' , portin , ' order by rand() limit 1 );');
select m.hostname as MACHINE_NAME, m.port as port, u.username as USERNAME, u.hostname as HOSTNAME, IF(STRCMP(u.password,PASSWORD(u.username)),'Empty Password','Password = Username') as PASSWORD
81
80
WHERE ( u.password='' or u.password=PASSWORD(u.username) )