Code: Select all
SELECT computer_name, date, user_id, department
FROM client_software
WHERE Software_1 = 'Microsoft Office' OR
Software_2 = 'Microsoft Office' OR Software_3 = 'Microsoft Office' OR Software_4 = 'Microsoft Office' OR Software_5 = 'Microsoft Office' OR
Software_6 = 'Microsoft Office' OR Software_7 = 'Microsoft Office' OR Software_8 = 'Microsoft Office' OR Software_9 = 'Microsoft Office' OR
Software_10 ='Microsoft Office' ORDER BY computer_nameFor example, if it found Microsoft Office in Software_4, it would also return that field name.