A-Z Index: Difference between revisions
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
tables=Veterans | tables=Veterans | ||
|fields=SUBSTRING(_pageName,1,1)=Letter, COUNT(_pageName)=Count | |fields=SUBSTRING(_pageName,1,1)=Letter, COUNT(_pageName)=Count | ||
|where=_pageName REGEXP "^[A-Z]" | |||
|group by=Letter | |group by=Letter | ||
|order by=Letter | |order by=Letter | ||
Revision as of 15:26, 19 February 2026
Iwo Jima Veterans Index
Error 3995: Character set 'utf8mb4_0900_ai_ci' cannot be used in conjunction with 'binary' in call to regexp_like.
Function: CargoSQLQuery::run Query: SELECT SUBSTRING(_pageName,1,1) AS `Letter`,COUNT(_pageName) AS `Count` FROM `mwhl_cargo__Veterans` `Veterans` WHERE _pageName REGEXP "^[A-Z]" GROUP BY `Letter` ORDER BY `Letter` LIMIT 100