user: ### NOW ANSWER:
Question: For the Cage Combat Fighting Championships: Mayhem, what was the record?
Columns: ['Res.', 'Record', 'Opponent', 'Method', 'Event', 'Round', 'Time', 'Location']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['Loss', '4-4', 'Mike Hayes', 'Submission (verbal)', 'Palace Fighting Championship: Best of Both Worlds', 2.0, '1:01', 'Lemoore, California , United States']
SQL:

assistant: SELECT "Record" FROM "Table" WHERE "Event" = 'Cage Combat Fighting Championships: Mayhem';