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