Below is my SELECT UNION Query of the same table.
It is functioning as we wanted but I have to believe there is a better or cleaner way to get the same result. We want to display columns from the same table entry as separate rows.
SELECT task1 AS Job FROM prevent WHERE task1 != “” AND eq = ? AND id = ?
SELECT task2 AS Job FROM prevent WHERE task2 != “” AND eq = ? AND id = ?
SELECT task3 AS Job FROM prevent WHERE task3 != “” AND eq = ? AND id = ?
This is an example of the table we are wanting to display.