INSERT INTO `name_format` (`id`, `sample`, `regex`, `ucfirst`, `toupper`) VALUES
(1, 'Do not format', NULL, NULL, NULL),
(2, 'F Lastname', '/^(.)[^\\s]*\\s([^\\s]+).*$/', 1, 0),
(3, 'Lastname', '/^[^\\s]*\\s?([^\\s]+).*$/', 1, 0),
(4, 'Firstname L', '/^([^\\s]+)\\s(.).*$/', 1, 0),
(5, 'Firstname', '/^([^\\s]+).*$/', 1, 0),
(6, 'FIRSTNAME LASTNAME', '/^(.*)$/', 0, 1);