MySQL: Ignore empty columns

I'm trying to select everything from pins except for empty columns. I still need a random pin with the multiplier to be selected at the end. Haven't figured out how to combine everything yet. I'm still learning and I guess you're the best to ask.

$sql = "SELECT * FROM cards, (SELECT * FROM pins ORDER BY -LOG(1.0 - RAND()) / Multiplier limit 1) AS list;";

source https://stackoverflow.com/questions/67826787/mysql-ignore-empty-columns