Thank you very much for your input, but I figure out a much simpler way to solving my problem AFTER RESEARCHING for hours ONLINE. This is the solution I came up with; however, I am still not happy that I couldn't place the trigger inside of a stored procedure. I know you are thinking, why do this when the trigger is only necessary? I thought so too but I am missing something that I don't know about stored procedures and triggers combined together? Here is my solution with just the trigger.
-- Create a trigger that will enforce that the Faculty's Email has to be
-- used in a standard way.
USE College ;
DROP TRIGGER IF EXISTS Faculty_Before_Insert;
CREATE TRIGGER Faculty_Before_Insert
BEFORE INSERT ON Faculty
FOR EACH ROW
IF NEW.Email NOT LIKE '%firstname.lastname@example.org%' THEN
SIGNAL SQLSTATE VALUE '45000'
SET MESSAGE_TEXT= '[table: Faculty]- email column is not valid';
END IF ;
INSERT INTO Faculty(LastName, FirstName, Email, HireDate, Salary, DepartmentID)
VALUES('Seals', 'Daron', 'email@example.com', current_date(), 20000, 1);
WHERE ID= last_insert_id();