Re: Newbie: Help with Match without using a subQuery

2005-04-14 Thread Graham Anderson
many thanks that was exactly what I needed. Building upon the initial question: Is there a way to get Match statements to do partial word searches...like %LIKE% ? For example, if the below Match Against query with 'chris' does not bring up anything... AND MATCH ( media.name, media.product

Re: Newbie: Help with Match without using a subQuery

2005-04-14 Thread SGreen
Graham Anderson [EMAIL PROTECTED] wrote on 04/14/2005 11:51:58 AM: many thanks that was exactly what I needed. Building upon the initial question: Is there a way to get Match statements to do partial word searches...like %LIKE% ? For example, if the below Match Against query with

Newbie: Help with Match without using a subQuery

2005-04-13 Thread Graham Anderson
Hi I am trying to set up my Match statements to filter the result of the main query [which works] If 'chris' does not exist in the first MATCH statement [AND MATCH (media.name, media.product)], then the results get a bit screwed up :( If the first match statement finds something, then the

Re: Newbie: Help with Match without using a subQuery

2005-04-13 Thread SGreen
Graham Anderson [EMAIL PROTECTED] wrote on 04/13/2005 01:46:35 PM: Hi I am trying to set up my Match statements to filter the result of the main query [which works] If 'chris' does not exist in the first MATCH statement [AND MATCH (media.name, media.product)], then the results get a bit