Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/22/2024 01:44 PM
SELECT SUBSTRING_INDEX(customproperty1, ',', 1) AS id
FROM users
UNION
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(customproperty1, ',', -2), ',', -1) AS id
FROM users