Set names to NN

From TNG_Wiki
Jump to navigation Jump to search

Some people want something in the empty space if there is no known first or lastname. Personally I prefer NN, but others might prefer unknown, or John or Jane Doe. (replace NN with anything you prefer so all the unknowns have the same name)

Nomen nescio, abbreviated to N.N. or NN, is used to signify an anonymous or non-specific person. From Latin nomen, name, and nescire, not to know, be ignorant of. Together, I do not know the name.

One use for this name is to protect against retaliation when reporting a crime or company fraud. In the Netherlands a police suspect that refuses to give his name is given an "N.N. number." In Germany, and Belgium, N.N. is also frequently seen in university course lists, indicating that a course will take place but that the lecturer is not yet known; the abbreviation is sometimes explained as "nomen nominandum" ("the name is to be announced") in this case.

N. N. is commonly used in the scoring of chess games, not only when one participant's name is genuinely unknown but when an untitled player faces a master, as in a simultaneous exhibition.

The generic name Numerius Negidius used in Roman times was chosen partly because it shared initials with this phrase.

Genealogists often use the abbreviation to signify an unknown or partially unknown name (such as N.N. Jones).

Copy and paste the text between the lines into the MySQL section of your MySQL admin, IMPORTANT: Make a backup before you try anything and use this at your own risk!


UPDATE tng_people SET lastname = "NN" where lastname = "";
UPDATE tng_people SET firstname = "NN" where firstname = "";
UPDATE tng_people SET firstname = "NN" where firstname = "onbekend";
UPDATE tng_people SET firstname = "NN" where firstname = "N.";
UPDATE tng_people SET firstname = "NN" where firstname = "n.n.";
UPDATE tng_people SET firstname = "NN" where firstname = "n.";
UPDATE tng_people SET firstname = "NN" where firstname = "N.N.";
UPDATE tng_people SET firstname = "NN" where firstname = "nn.";
UPDATE tng_people SET firstname = "NN" where firstname = "N.n.";
UPDATE tng_people SET firstname = "NN" where firstname = "Nn";
UPDATE tng_people SET firstname = "NN" where firstname = "Levenloos";
UPDATE tng_people SET firstname = "NN" where firstname = "levenloos";
UPDATE tng_people SET lastname = "NN" where lastname = "?";
UPDATE tng_people SET firstname = "NN" where firstname = "?";
UPDATE tng_people SET firstname = "NN" where lastname = "???";
UPDATE tng_people SET firstname = "NN" where firstname = "???";
UPDATE tng_people SET firstname = "NN" where firstname = "Doodgeboren";
UPDATE tng_people SET firstname = "NN" where firstname = "Infant";
UPDATE tng_people SET firstname = "NN" where firstname = "Stillborn";
UPDATE tng_people SET firstname =REPLACE(firstname,'?','');
UPDATE tng_people SET lastname =REPLACE(lastname,'?','');