[thelist] mysql query help

[Carlos Costa Portela]

On Wed, 23 Oct 2002, Kevin wrote:
> Members
> ========
> MemberID (unique)
> Name
> Address
>
>
> Credits
> ========
> CreditID
> MemberID
> Project
> Title
>
> Credit_Images
> =========
> ImageID
> CreditID
> Location
> Comments
>
> Showroom
> =========
> ShowroomID
> MemberID
> Size
> Comments
>
> I need to do a full search on all the fields (except ID) and return a list
> of names from the members table. I am kind of stuck - any help will be
> appreciated.

The first approach could be something like

select Name from Members,Credits,Credit_Images,Showroom where
	Credits.MemberID = Members.MemberID and
	Showroom.MemberID = Members.MemberID and
	Credits.CreditID = Credit_Images.CreditID and
	(Name like '%$keyword%' or
         ...
	)

but I think that it's better create a new table like

create table keywords (
	MemberID int,
	keyword varchar(255),
);

and populate it with all the keywords, so do the search could be something
like

select Name from Members,keywords where Members.MemberID=keywords.MemberID
and keyword = '$keyword';

it is simpler and faster.

	Hope this helps,
		Carlos.


       [ http://www.biologia.org/ :: portal especializado en Biología ]
_______Carlos Costa Portela_________________________________________________
| e-mail:  ccosta at servidores.net | home page: http://casa.ccp.servidores.net |
|_____Tódalas persoas maiores foron nenos antes, pero poucas se lembran______|