[thelist] SQL: Searching a field with mutiple names

Jon Haworth jhaworth at witanjardine.co.uk
Thu Aug 2 11:13:02 CDT 2001


Well, '%foo%' works fine for me (and the other 50 or so searches run each
day on the intranet here). I just tested by searching for "nfor" and it
returned pages with "information" in them, so I guess everything is OK - at
least, with MySQL.

Cheers
Jon


-----Original Message-----
From: Tab Alleman [mailto:Tab.Alleman at RealMetros.com]
Sent: 02 August 2001 16:52
To: thelist at lists.evolt.org
Subject: RE: [thelist] SQL: Searching a field with mutiple names


but, but, but... ummm, 

are you sure you're supposed to use '%foo%' with LIKE?   I think it
might just be %foo%... if you put it in single-quotes, won't it
literally look for "%foo%"?  Or maybe it should be %'foo'%

grrrr, no sql reference handy.  sorry.

HTH
Tab




More information about the thelist mailing list