If I have a table with a field url of type VARCHAR(50), I would like to use the WHERE clause to match certain domains, what should I do?
eg.
url http://www.excite.com/123.html http://www.excite.com/456.html http://www.excite.com/789.html http://www.yahoo.com/123.html http://www.yahoo.com/456.html http://www.yahoo.com/789.html http://www.goto.com/123.html http://www.goto.com/456.html http://www.goto.com/789.html
and I would like to use the WHERE clause to match the entries where the url containing the string "yahoo", how do I do this?
select * from table where field like '%yahoo%' ...
Thanks, and by the way, are the two % necessary? what is it for?
%text = search ends with text ("some text") %text% = search has text ("a black texture") text% = starts with text ("texting is hard, reading manuals, easier")
// Thomasson "Need help spelling m a n u a l?"
They're wild cards....
