I have a problem with the following trigger
CREATE TRIGGER DEPORTES_AFTER_INSERT
AFTER ISERT ON CONTENIDO
FOR EACH ROW
INSERT INTO c_deportes
(c_id, c_titulo, c_descripcion, c_categoria, c_fecha_entrada, c_contenido, c_imagen, c_nombre_imagen)
values (new.c_id, new.c_titulo, new.c_descripcion, new.c_categoria, new.c_fecha_entrada, new.c_contenido, new.c_imagen, new.c_nombre_imagen)
It is correct. corresponds to the entries in a blog. But how do I make every time I register a post , only the post that has the category "SPORTS" and not all the posts is loaded. Because with that trigger he is inserting all the records to c_sports and I do not want that. could a clause be established where?