[thelist] SQL question

Tom Dell'Aringa pixelmech at yahoo.com
Wed Jan 22 13:52:01 CST 2003

--- rudy <r937 at interlog.com> wrote:
> > 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'

Ahhhh duh.

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

Yes, it will be a first or last name of a man or a woman. Do I need
to use DISTINCT in case I have 2 men whose first name is George?

var me = tom.pixelmech.webDeveloper();

[Making A Commercial Case for Adopting Web Standards]

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.

More information about the thelist mailing list