Problem searching for domains ending in....

[perky416]

Hi everyone,

 

Im trying to create a search box for searching domain names on my website where the domain ends in a keyword entered in a text box. The problem im having is that the tld is hampering the search. As an example lets say im trying to search for the domain "test.com" by typing "est" in the search box. Nothing comes up because the domain stored in my database ends in .com, does anybody know a way i can exclude the tld?

 

If excluding the tld is not possible or is complicated is doing something like the code below possible? I know its not written correctly im just trying to get across what im trying to accomplish.

 

$tld = array('.com','.net','.co.uk');
mysql_query("SELECT domain_name FROM domains WHERE domain_name LIKE '%" . $_POST['keyword'] . $tld);

 

Please could somebody give me some pointers?

Many thanks.

[efficacious]

i would look into using some sort of SQL regular expressions

 

http://dev.mysql.com/doc/refman/5.1/en/regexp.html

 

wish i could help you more this is a good thing to learn how to do.

[perky416]

Hi efficacious

 

I got it to work simply by adding ".%" after the keyword, so basically the query is searching for anything keyword . anything.