You can use the "LIKE" operator and the "%" wildcard. For the "C#" tag it would be:
WHERE (title LIKE '%C#%') OR (body LIKE '%C#%');
If you need to search for more than one tag at a time, you can build a loop.
If you don't fancy joining over 2 tables as shown in the answer by Glorfindel you can String_Split the Tags field (which will hold <c#><python> in your example) and then juggle a bit with the value you get. The tag value will have a > at the end and with a Left function we strip that off.
Notice that I use a collation to cater for differences ...
You have to JOIN with the PostTags and Tags tables, e.g. like this query:
SELECT TOP 10 p.Id AS [Post Link], p.Tags
FROM Posts AS p
INNER JOIN PostTags AS pt
ON p.Id = pt.PostId
INNER JOIN Tags AS t
ON t.Id = pt.TagId
WHERE ' ' + p.Title + ' ' LIKE ' %' + t.TagName + ' %'
OR ' ' + p.Body + ' ' LIKE ' %' + t.TagName + ' %'
I'm not sure ...
I strongly agree with the proposal "It should be possible to retag a question without bumping it to the front page", hence my similar post to Aviation Stack Exchange Meta ( Could we arrange things so that simply editing the tags doesn't bump a question up to the top of the "active" list? ), and my upvote to the question on SE Meta. I ...
Current maintainer of Highlight.js here. I wanted to weigh in on this. First off, a LOT of great ideas here. But I want to nitpick the leading comment just a tiny bit:
highlight.js's current auto-detection is arguably poor
It definitely can be argued. :-) It's definitely not perfect; and perhaps it's worse than Prettify, I don't know... perhaps you ...
You can achieve that by querying the PostHistory table. The rows with PostHistoryTypeid = 3 will hold the initial tags. The rows with PostHistoryTypeid = 6 will hold the tags on subsequent edits. The Text field of those rows hold the tags in the format <tag1><tag2><tag3>. So we query for records with type 6 and the tag. And then we remove ...
I've modified that query by adding
COUNT(DISTINCT(Posts.Id)) AS [Number of answers],
and making the join to the Votes table an outer join, since answers which aren't voted upon count as well. This is the result:
Here is that query.
Notice I join the tables posts, posttags and tags. In the columns I sum the score, once for all posts and once only for posts that are not community wiki. I also included the vote split in up and downvotes and the number of acceptvotes.
select rank() over(order by sum(p.score) desc
, sum(acceptvotes) desc
You have posted this in the right place. Bug reports are accepted on any meta site. This site you're now on is for bugs that are affecting all sites, post on a per-site meta if the bug is only visible / relevant for that specific site. See also the Help: https://meta.stackexchange.com/help/give-feedback
There are links to the help center in both the topbar (...
Answers have no tags, only questions, hence the answer entries in the search results show no tags.
There is a pending feature request to change this existing behavior:
Include tags in answers entries on search results so you can support this by upvoting/bounty if you like.
One of the benefits of having all three of these tags is that, per the deleted-questions tag usage guidance:
You can also use this tag along with [specific-question] and [meta] to ask why a specific question on Meta Stack Exchange was deleted.
The same goes for deleted-answers, though its tag wiki does not reflect it at the moment. It's useful to have ...