sql trigger to update based on specific column is updated and if value is equal to 'x'

CREATE TRIGGER Sample ON [dbo].[FileContent]
FOR UPDATE
AS
BEGIN
   IF UPDATE([Content])
   BEGIN
      DECLARE @nFieldID AS INT

      SELECT @nFieldID  = [FileId] FROM INSERTED

       UPDATE  [dbo].[FileContent] 
       SET [UpdateTime] = GETDATE() 
       WHERE [FileId] = @nFieldID    
   END    
END

USE [lms_db]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[updateLM_TIME]
ON [dbo].[INSTITUTIONS]

AFTER INSERT, UPDATE 
AS

IF NOT UPDATE(CLIENT_SYNCED_TIME)

BEGIN

UPDATE dbo.INSTITUTIONS
SET lm_time = CONVERT(DATETIME, CONVERT(VARCHAR(20), GETDATE(), 120))
WHERE ID IN (SELECT DISTINCT ID FROM Inserted)

END

CREATE TRIGGER update_user_deleted_date BEFORE UPDATE ON users
FOR EACH ROW BEGIN
IF (LOCATE('NEW_', NEW.name) != 0) THEN
    SET NEW.date_deleted = NOW();
END IF;
END;

CREATE TRIGGER dbo.tr_Test ON dbo.Test FOR UPDATE
AS

    INSERT INTO test_audit (Id, Name, [Status], [time stamp])
    SELECT Id, Name, [Status], GETDATE()
    FROM Inserted I
    WHERE I.[Status] = 'APPROVED'
    AND EXISTS
    (
         SELECT 1
         FROM Deleted D
         WHERE D.Id = I.Id -- assuming primary key column is called id...
         AND D.[Status] <> 'APPROVED'
    )