[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