[thelist] mysql query help

[Kevin]

Hello,

I have the following table structure and need assistance on a mysql query:

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.

I am running on version 3.23 so full-text is not available

Thanks.

--Kevin