SQL
x
SELECT Pd.page_title, LOCATE("_and", Pd.page_title),
SUBSTRING(Pd.page_title, LOCATE(Pd.page_title, "_and_")+6, 1),
CONCAT(SUBSTRING_INDEX(Pd.page_title, "_and_", 1),"_and_",
UPPER(CONVERT(SUBSTRING(Pd.page_title, LOCATE("_and_", Pd.page_title)+6, 1) USING latin1)),"###",
SUBSTRING(Pd.page_title, LOCATE("_and_", Pd.page_title)+7))
FROM page Pd
WHERE page_title = "Food_and_drink" AND page_namespace=0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.