[thelist] SQL question
rudy
r937 at interlog.com
Wed Jan 22 14:46:06 CST 2003
> Could you do:
> ...
> where manFirst+manLast+womFirst+womLast like '$searchname'
in practice, i don't see why not, assuming you concatenate properly -- for
example, in some databases you have to use & and in others || and in yet
another CONCAT() <sigh />
however, you could theoretically have unexpected results, for example -- and
you can tell i'm making this up -- if manFirst='Gregor' and
manLast='Doncaster' and you were searching for '%gordon%'
rudy
More information about the thelist
mailing list