MySQL: searh by host name in field containing urls
- by Silver Light
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?