I want to see if a table contains any sub-string of a given string.
Let's say I have a string
In database I have:
blabladomain.com testdomain.com domain.com
I need to make a query that will return "domain.com" as it is a substring of "somedomain.com".
I don't know if this is even possible in MySQL.
CREATE TABLE `site_core_antispam_banned_domain` ( `domain_id` int(11) NOT NULL AUTO_INCREMENT, `domain_name` varchar(255) NOT NULL, PRIMARY KEY (`domain_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;