[thelist] SQL question
rudy
r937 at interlog.com
Wed Jan 22 13:44:00 CST 2003
> how do I search 4 fields for the same name?
select { standard list of columns }
from reguser
where manFirst like '$searchname'
or manLast like '$searchname'
or womFirst like '$searchname'
or womLast like '$searchname'
presumably you would return not just the field being searched in the SELECT
list, but rather, a set of columns that gives the result set some context
also, your variable $searchname contains the appropriate wildcards, right?
rudy
More information about the thelist
mailing list