Anonymous user
Template:Lowercase title/doc: Difference between revisions
Adding SQL
(Undid revision 740798999 by GreenComputer (talk) Dosen't work) |
(Adding SQL) |
||
Line 26:
== Technical ==
This template wraps the [[Help:Magic words|magic word]] DISPLAYTITLE so that it works automatically in any namespace (main, talk, template, etc.) to decapitalise the first letter of the name of a page it is transcluded on.
<source lang=sql>
/* Page using a lowercase title, with or without {{lowercase}} */
SELECT page_title, pp_value AS displaytitle
FROM page
JOIN page_props ON pp_page=page_id AND pp_propname="displaytitle"
WHERE page_namespace=0
AND CONVERT(pp_value USING utf8mb4) COLLATE utf8mb4_bin /* &#greek; */
REGEXP "^([_ :]+|<[^<>]+>)*([[:lower:]]|	[4-6][0-9];)"
</source>
== See also ==
| |||