[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

Yes

> 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();

http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



More information about the thelist mailing list