[SQL] Adding a parameter to a trigger

Hi together, I am still trying to implement my "userlog". At the moment I can insert a message like "User xy added". What I want to have is, that I can insert something like "User xy added by z". Can anyone tell me, how to parse a parameter to the trigger (I think, only the application knows what

[SQL] automated log-messages

Hi, I am trying to implement an automated log-message system for my application. For example, if a new user is inserted to my table "auth", I want to create a log message like: "user [name] added to system". Is it possible to add this message with triggers or rules?! If so, can anyone give some e

[SQL] case insensitive search

Hello together, how can I handle case insensitive search in a table? -- Linux is like wigwam - no windows, no gates, apache inside. In diesem Sinne Joern