SELECT 
 `profile` 
 
FROM 
 `visit` 
 
WHERE 
 NOT( ( `ip` IS NULL ) OR ( `ip` = '' ) );