[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