[20:43:21] <wm-bb>	 [telegram] <Adithya> Consider the article abc/xyz. Is there any method by which I can retrieve all the pages with the word containing /xyz in the page title?
[20:52:10] <Reedy>	 SQL query maybe
[20:52:20] <Reedy>	 There's a request to have a SuffxIndex like PrefixIndex
[20:52:52] <wm-bb>	 [telegram] <Adithya> Ohk. Will it be possible using regex?
[20:53:18] <wm-bb>	 [telegram] <Adithya> Like "something followed by /xyz"
[20:55:49] <Reedy>	 where page_title LIKE '%/xyz' should work in SQL
[20:55:52] <Reedy>	 But it's not gonna be fast
[20:56:18] <wm-bb>	 [telegram] <Adithya> Ok. Let me check it
[21:04:22] <wm-bb>	 [telegram] <Thecladis> Well, LIKE is usually only slow if wildcard is on the both sides 🙂
[21:06:17] <Reedy>	 https://phabricator.wikimedia.org/T12808
[21:06:20] <Reedy>	 >No DB support for doing this efficiently.
[21:06:46] <wm-bb>	 [telegram] <Adithya> Ok
[21:11:12] <wm-bb>	 [telegram] <Thecladis> Cannot it rely on elastic? (re @wmtelegram_bot: [irc] <Reedy> >No DB support for doing this efficiently.)
[21:11:43] <Reedy>	 Brions comment is from 2007 ;)
[21:11:53] <Reedy>	 I mean, in theory, yes. But it couldn't be a core MW feature like that
[21:12:17] <Reedy>	 And Gergo suggested that in 2015 ;P
[21:12:57] <wm-bb>	 [telegram] <Thecladis> Nice
[21:14:00] <wm-bb>	 [telegram] <Thecladis> Oh, and Izno's comment basically says that it already works
[21:14:37] <wm-bb>	 [telegram] <Thecladis> If someone searches intitle:/.*\/foo/ I guess or something