MySQL: searh by host name in field containing urls

Question

Hello!

I have this database table:

id  | url
-----------------------------------------
1   | http://stackoverflow.com/
2   | http://www.google.com
3   | http://example.com/somepage
4   | https://another.net?id=88
5   | http://hello.org/index.php?hello=2
6   | http://google.com?q=hello+world

I need to search all fields, where URL belongs to a certain host.

For example, if I give the query 'google.com', it will return rows 2 and 6 (www is ignored). I get the host using PHP parse_url() function.

How this SQL query would look like?

Answer 1

SELECT * FROM table_name WHERE url like '%host_name%'

Replace table_name with the name of your table and replace host_name with the name of the host you are looking for to be contained in the url.