[thelist] SQL question

Lonnie Kraemer lwkraemer at earthlink.net
Wed Jan 22 14:11:01 CST 2003


> select    { standard list of columns }
>   from reguser
>  where manFirst like '$searchname'
>     or manLast like '$searchname'
>     or womFirst like '$searchname'
>     or womLast like '$searchname'

Could you do:
...
where manFirst+manLast+womFirst+womLast like '$searchname'

?



More information about the thelist mailing list