From: Steffan A. Cline Date: October 7 2007 7:26pm Subject: My first trigger in MySQL List-Archive: http://lists.mysql.com/mysql/209426 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit I am new to triggers and am trying to figure this out. The goal I have is to set it up so that after a row in the users table is updated it will check to see if the affected row has a username in the username field and if not to update that row with a concatenation of firstname + " " + lastname. Does anyone have a good example of how to do this? Thanks Steffan --------------------------------------------------------------- T E L 6 0 2 . 7 9 3 . 0 0 1 4 | F A X 6 0 2 . 9 7 1 . 1 6 9 4 Steffan A. Cline Steffan@stripped Phoenix, Az http://www.ExecuChoice.net USA AIM : SteffanC ICQ : 57234309 YAHOO : Steffan_Cline MSN : steffan@stripped GOOGLE: Steffan.Cline Lasso Partner Alliance Member ---------------------------------------------------------------