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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php