Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
UPDATE `#__comprofiler` SET `firstname` = CONCAT( UCASE( substr( `firstname`, 1, 1 ) ), substr( `firstname`, 2 ) ) WHERE `id` = '[user_id]'
UPDATE `#__comprofiler` SET `firstname` = CONCAT( UCASE( substr( `firstname`, 1, 1 ) ), LCASE( substr( `firstname`, 2 ) ) ) WHERE `id` = '[user_id]'
Please Log in to join the conversation.
Please Log in to join the conversation.
You're missing a trigger. Your query also has unnecessary line breaks; try to keep it 1 line and let it wordwrap if needed.Does this set up look ok?
Yup, end your first query with a ; then add a line break (press enter/return) and add a new query. You can add as many as you like actually.Can I run more than one query in the box so I can also do firstname and lastname with one trigger?
Please Log in to join the conversation.