| select * from pagetriage_log limit 50 |
2 years ago |
| SELECT * FROM logging where log_page = 2986178; |
2 years ago |
| SELECT * FROM logging where page_id = 2986178; |
2 years ago |
| SELECT log_params, REGEXP_SUBSTR(SUBSTR(log_params, REGEXP_INSTR(log_params,... |
2 years ago |
| SELECT log_params, REGEXP_SUBSTR(SUBSTR(log_params, REGEXP_INSTR(log_params,... |
2 years ago |
| SELECT *, SUBSTR(log_params, REGEXP_INSTR(log_params,... |
2 years ago |
| SELECT *, SUBSTR(log_params, REGEXP_INSTR(log_params,... |
2 years ago |
| SELECT *, REGEXP_SUBSTR(log_params, '(?<="4::target";s:)[0-9]*') FROM... |
2 years ago |
| SELECT *, REGEXP_SUBSTR(log_params, '("4::target";s:)[0-9]*') FROM logging... |
2 years ago |
| SELECT *, REGEXP_SUBSTR(log_params, '(4::target";s:)[0-9]*') FROM logging... |
2 years ago |
| SELECT * FROM logging where log_type = 'move' and log_timestamp >=... |
2 years ago |
| SELECT * FROM logging where log_type = 'create' limit 100 |
2 years ago |
| SELECT * FROM logging where log_type = 'move' limit 100 |
2 years ago |
| SELECT log_params, log_params LIKE '%u%' FROM logging where log_params limit 100 |
2 years ago |
| SELECT log_params, log_params LIKE '%a%' FROM logging where log_params limit 100 |
2 years ago |
| SELECT log_params, log_params LIKE '%a%' FROM logging where log_params IS... |
2 years ago |
| SELECT log_params, log_params LIKE '%a%' FROM logging limit 100 |
2 years ago |
| SELECT * FROM logging WHERE log_params LIKE 'Draft:%' limit 10 |
2 years ago |
| describe logging; |
2 years ago |
| describe content; |
2 years ago |
| show tables; |
2 years ago |
