I just tried SELECT DISTINCT and still the same problem -- returning all
entries for a matching user_id in art for each user where the word 'kansas'
is specified... any other thoughts? Thanks, lje
On Saturday 03 January 2004 16:58, you wrote:
> Hi Ladd,
>
> How about SELECT DISTINCT?
>
>
> Hope that helps.
>
>
> Matt
>
>
> ----- Original Message -----
> From: "Ladd J. Epp"
> Sent: Saturday, January 03, 2004 11:39 AM
> Subject: FULLTEXT across two tables
>
> > Hello,
> >
> > I would like to do a FULLTEXT search across two tables. I run an
>
> artist
>
> > website, so I need to search across the user list and the users'
>
> associated
>
> > art pieces list. I've come up with this query (fulltext indexes for
>
> these
>
> > precise values have been created on both tables):
> >
> > SELECT * from users INNER JOIN art ON (users.user_id = art.user_id)
> > WHERE MATCH (nickname, name_first, name_last, name_middle, city,
>
> state,
>
> > zip_area, country, bio_short, bio_desc) AGAINST ('kansas')
> > OR MATCH (title, medium, commentary) AGAINST ('kansas');
> >
> > This query is very close to what I need, except that it returns
>
> redundant
>
> > rows. For example, if users.state='kansas' it returns every record
>
> from art
>
> > where users.user_id=art.user_id. How do I return records that have
>
> 'kansas'
>
> > in either users, or art, or both, only once? I think a UNION might
>
> help me
>
> > here, but my provider uses MySQL v.3.22 so that is not an option...
> >
> > I apologize if I am not being clear about something ... If you need
>
> more
>
> > detail I would be happy to provide it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
