Difference between revisions of "User:Subfader/ignorecase titlematch"

From FollowTheScore
Jump to: navigation, search
(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