wikiadmin@deployment-db04[enwiki]> select * from interwiki WHERE iw_url LIKE '%ca.wikipedia%';
+-----------+----------------------------------------------+--------+-----------+----------+----------+
| iw_prefix | iw_url                                       | iw_api | iw_wikiid | iw_local | iw_trans |
+-----------+----------------------------------------------+--------+-----------+----------+----------+
| ca        | http://ca.wikipedia.beta.wmflabs.org/wiki/$1 |        |           |        1 |        0 |
+-----------+----------------------------------------------+--------+-----------+----------+----------+
1 row in set (0.00 sec)