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