I thought you only could use the likesyntax like this; SELECT column from table where column like '%data%';
i have a hard time seeing what goodit would be calling a column http://.... =) check; http://www.mysql.com/doc/en/Pattern_matching.html regards lasse On Sun, 23 Mar 2003, Ville Mattila wrote: > > 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 > > Hi! > > How about the following? > > SELECT URL, Name FROM websites WHERE > 'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12' LIKE CONCAT(URL, > '%'); > > - Ville > > > -- -----BEGIN GEEK CODE BLOCK----- Version: 3.1 (2002 update) GCM/GCS/GMU/ d+ s++:++ a-- C++(++++) UBLAIS+(++++) P+ L+(-) E--- W+++ N+ o-- K w O- M- V- PS(+++) PE++ Y PGP- t 5+ X++ R- tv+ b+ DI+++ D- G e h++ r% y++ ------END GEEK CODE BLOCK------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
