It seems that underscore (_) is a wildcard character in Data Explorer. How do I escape it to search for an actual underscore?
Better - is there any indexing on words a la Lucene or RegEx support that I can access in the Data Explorer or do I have to do brute-force LIKE queries?
Even better - is there any way to do a search based on text, not markdown code?
For example, if I want to find all posts with the word "bat" in them (not the words "batch" or "rebate") but don't care if there's some formatting around "bat", do I have to write:
select [Post Link] from Posts
where body like '% bat %'
or body like '% *bat* %'
or body like '% *bat* %'
or body like '% bat* %' ... etc.