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?