mknparreira/postegre-sql-regex.md

Last active August 12, 2021 22:27

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mknparreira/0541d17f450627f6be553fc086f98f10.js"></script>
Save mknparreira/0541d17f450627f6be553fc086f98f10 to your computer and use it in GitHub Desktop.

PostegreSQL | Just a simple REGEX

Raw

SQL REGEX

SELECT *
FROM tasks
WHERE `dependency` REGEXP 's:[0-9]+:".*33.*".*'

Author

SELECT *
FROM tasks AS T1
WHERE T1.id NOT IN (
SELECT T2.id FROM tasks AS T2 WHERE T2.dependency REGEXP 's:[0-9]+:".33.".*'
)