mysql - query sql need to resolve -

in table keybank there's 100.000 terms, want make sitemap list a, b, c, d showing data (id) 1 5000 not 100.000 in group a, b, c, d

$data = 'a'; $where = "select * keybank left(title,1) = '".$data."' order title asc"; 

if using mysql workbench, maybe have default setting limiting query default (edit -> preferences -> sql queries -> untick "limit rows"). credit goes post: remove limit clause mysql workbench .

also, might alternatively try append limit 999999 @ end of query overwrite default limit.

you try adding before running query: set sql_select_limit=100000;