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

From FollowTheScore
Jump to: navigation, search
(Solution)
 
Line 36: Line 36:
  
 
  LOWER('.$sPageTable.'.page_title)
 
  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