[thelist] SQL question

rudy r937 at interlog.com
Wed Jan 22 15:28:01 CST 2003


> I understand how the wildcard works, but I do want
> an exact match, not a close match.

okay, then you might as well code it as

 where groom = 'george'
   or groomf = 'george'
   or bride = 'george'
   or bridef = 'george'

this is bound to run faster than LIKE without wildcards


> OR  bridef LIKE '$searchname'");

looks like an extra quote at the end there



More information about the thelist mailing list