Query Run
SELECT * from redirect where rd_namespace=2 #and rd_interwiki like "%m%:"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_interwiki like "%m%:"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_interwiki like "%meta%:"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_interwiki is like "%meta%:"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_interwiki like "%meta%:"; 3 years ago
SELECT * from redirect where rd_namespace=2 #and rd_title like "%meta%:"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_title like "meta:"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_title like "%meta%"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_title like "%meta:%"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_title like "%m:%"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_title like "%m:%" OR "%meta:%"; 3 years ago
SELECT * from redirect where rd_namespace=2 and rd_title like "%m:%" OR "%meta:%"; 3 years ago
select * from redirect where rd_namespace=0 and rd_title like "%|%"; 3 years ago