Template:Lowercase title/doc: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
(Undid revision 740798999 by GreenComputer (talk) Dosen't work) |
(Adding SQL) |
||
Line 26: | Line 26: | ||
== Technical == |
== 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. |
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 == |
== See also == |