Find tags that only differ by hyphenation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- Find tags that only differ by hyphenation

SELECT a.TagName AS First, b.TagName AS Second
FROM Tags AS a, Tags AS b
WHERE a.Id < b.Id
AND REPLACE(a.TagName, '-', '') = REPLACE(b.TagName, '-', '');

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached