Using LIKE to search for occurence of a column value in a string

[Jakob Vedel Adeltoft]

I wan't to search for all rows that match a value.

I have these rows:
URL                                             Name
'http://www.microsoft.com/kb/'  Microsoft Knowledgebase
'http://www.microsoft.com/search/'      Microsoft Search

Now I wan't to find all occurences where any of above URL columns exist in the string 
'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12'.

I tried to use LIKE:
SELECT URL, Name
FROM websites
WHERE 'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12' LIKE (URL + '%');

But this doesn't return any results. I would like the following as output:
'http://www.microsoft.com/kb/'  Microsoft Knowledgebase


Plz help me:)

/Jakob

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]