MySQL search domains by tld

Hi Guys!

I have a MySQL database that contains domain names and I need to search them by extension (i.e .com, .co.uk, .org etc..).

Domains are stored in the database in this format:

mydomain.com
mytest.org

Let's say I wanted to search the above records and return all rows with .com?

WHERE domain LIKE '%.com'

store two columns for the domain -- the domain itself and the tld -- and put an index on bofadem

then your search will be efficient --

Code:

---

WHERE tld = 'co.uk'

---