How to build this query?

Question

SQL

There is a table of sites, it has a column with domain.

How to get a list of all top level domains?
For example, I can choose:

select * from `sites` where `domain` regexp '.(ru)$'

And how to get an array of top-level domains that are now in the database, I don’t know how (

Response Example

Request and response: ['ru',shop','com'......]

Answer 1

SUBSTRING_INDEX() function