Difference between revisions of "User:Subfader/ignorecase titlematch"
From FollowTheScore
(Created page with "{| | style="vertical-align:top" |<pre> {{#dpl: |namespace= |titlematch=%LoadTest% |count=10 }} </pre> {{#dpl: |namespace= |titlematch=%LoadTest% |count=10 }} | style="v...") |
(→Solution) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
| style="vertical-align:top" |<pre> | | style="vertical-align:top" |<pre> | ||
{{#dpl: | {{#dpl: | ||
| + | |debug=3 | ||
|namespace= | |namespace= | ||
|titlematch=%LoadTest% | |titlematch=%LoadTest% | ||
| Line 9: | Line 10: | ||
</pre> | </pre> | ||
{{#dpl: | {{#dpl: | ||
| + | |debug=3 | ||
|namespace= | |namespace= | ||
|titlematch=%LoadTest% | |titlematch=%LoadTest% | ||
| Line 15: | Line 17: | ||
| style="vertical-align:top" |<pre> | | style="vertical-align:top" |<pre> | ||
{{#dpl: | {{#dpl: | ||
| + | |debug=3 | ||
|namespace= | |namespace= | ||
|titlematch=%loadtest% | |titlematch=%loadtest% | ||
| Line 22: | Line 25: | ||
</pre> | </pre> | ||
{{#dpl: | {{#dpl: | ||
| + | |debug=3 | ||
|namespace= | |namespace= | ||
|titlematch=%loadtest% | |titlematch=%loadtest% | ||
| Line 28: | Line 32: | ||
}} | }} | ||
|} | |} | ||
| + | |||
| + | == Solution == | ||
| + | |||
| + | LOWER('.$sPageTable.'.page_title) | ||
| + | |||
| + | http://stackoverflow.com/questions/2876789/case-insensitive-for-sql-like-wildcard-statement | ||
Latest revision as of 16:53, 16 November 2014
{{#dpl:
|debug=3
|namespace=
|titlematch=%LoadTest%
|count=10
}}
|
{{#dpl:
|debug=3
|namespace=
|titlematch=%loadtest%
|ignorecase=true
|count=10
}}
Extension:DynamicPageList (DPL), version 3.2.1: Warning: No results. |
Solution
LOWER('.$sPageTable.'.page_title)
http://stackoverflow.com/questions/2876789/case-insensitive-for-sql-like-wildcard-statement
