[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?


More information about the thelist mailing list