use dewiki_p;
select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... |
4 years ago |
use dewiki_p;
select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... |
4 years ago |
use dewiki_p;
select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... |
4 years ago |
use dewiki_p;
select 'ipblocks.ipb_reason_id','comment.comment_text',... |
4 years ago |
use dewiki_p;
select 'ipblocks.ipb_reason_id','comment.comment_text',... |
4 years ago |
use dewiki_p;
select 'ipblocks.ipb_reason_id','comment.comment_text',... |
4 years ago |
use dewiki_p;
select 'ipblocks.ipb_reason_id',`comment.comment_text`,... |
4 years ago |
use dewiki_p;
desc ipblocks; |
4 years ago |
use dewiki_p;
select `ipblocks.ipb_reason_id`,`comment.comment_text`,... |
4 years ago |
use dewiki_p;
select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... |
4 years ago |
use dewiki_p;
select ipb_reason_id, count(*) from ipblocks GROUP... |
5 years ago |
use dewiki_p;
select ipb_reason, count(*) from ipblocks GROUP... |
6 years ago |
use dewiki_p;
select distinct(ipb_reason) from ipblocks; |
6 years ago |
use dewiki_p;
select ipb_reason, count(*) from ipblocks GROUP... |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where LOWER(ipb_reason) rlike... |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where (ipb_reason) rlike... |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where (ipb_reason) rlike "GLGerman"; |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where (ipb_reason) rlike "glgerman"; |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where LOWER(ipb_reason) rlike... |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where upper(ipb_reason) rlike... |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where lower(ipb_reason) rlike... |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where ipb_reason irlike "glgerman"; |
6 years ago |
use dewiki_p;
select count(*) from ipblocks where ipb_reason rlike "GLGerman"; |
6 years ago |
use dewiki_p;
select distinct(ipb_reason) from ipblocks where ipb_reason... |
6 years ago |
use dewiki_p;
select distinct(ipb_reason) from ipblocks where ipb_reason... |
6 years ago |
select distinct(ipb_reason) from ipblocks; |
6 years ago |
select ipb_address from ipblocks where ipb_reason rlike ".*glgerman.*"; |
6 years ago |
select ipb_address from ipblocks where ipb_reason rlike "glgerman"; |
6 years ago |
select ipb_address from ipblocks where "ipb_reason" rlike "glgerman"; |
6 years ago |
select ipb_address from ipblocks where "ipb_reason" irlike "glgerman"; |
6 years ago |
select ipb_address from ipblocks where "ipb_reason" rlike "Über diesen Zugang".*; |
6 years ago |
select ipb_address from ipblocks where "ipb_reason" rlike "Über diesen Zugang.*"; |
6 years ago |
select ipb_address from ipblocks where "ipb_reason" rlike "Über diesen Zugang"; |
6 years ago |
desc ipblocks; |
6 years ago |
show tables; |
6 years ago |
use dewiki_p; |
6 years ago |
user dewiki_p; |
6 years ago |
show tables; |
6 years ago |