exact text search in Wikidata labels/descriptions/aliases

Query to search for an exact string in labels, descriptions or aliases of any item in any language (but not other statements or entity types).

SQL

SELECT CONCAT('Q', wbit_item_id), wbxl_language, wby_name, wbx_text -- use CONCAT('P', wbpt_property_id) when searching wbt_property_terms
FROM wbt_item_terms -- can also be wbt_property_terms, but not lexicographical data
JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id -- use wbpt_term_in_lang_id when searching wbt_property_terms
JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
JOIN wbt_text ON wbxl_text_id = wbx_id
JOIN wbt_type ON wbtl_type_id = wby_id
WHERE wbx_text = 'universe'; -- change text here; LIKE 'prefix%' is also efficient

SQL

Checking query status...