[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