By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `docs` (
`id` int(6) unsigned NOT NULL,
`content` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO `docs` (`id`, `content`) VALUES
('1', '10-20-30-4-5'),
('2', '30-40-50-7-8'),
('3', '40-20-10-50-9'),
('4', '50-40-30-10-0');
SELECT *
FROM `docs` a
WHERE a.content REGEXP '^(?:(?:10()|20()|30()|40()|50()|\\d+)(?:-|$))+$(?:\\1\\2\\3\\4|\\1\\2\\3\\5|\\1\\2\\4\\5|\\1\\3\\4\\5|\\2\\3\\4\\5)';
Records: 4 Duplicates: 0 Warnings: 0
| id | content |
|---|---|
| 3 | 40-20-10-50-9 |
| 4 | 50-40-30-10-0 |