That's the syntax used to do a full-text search in MySQL. Here's some light reading:
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine GH <[EMAIL PROTECTED]> wrote on 09/28/2004 03:14:21 PM: > I know that this is off topic and such... but can you explain the > Match / Against that you used in your query? i have never seen syntax > like that in SQL > > > On Tue, 28 Sep 2004 14:16:56 -0400, Eve Atley <[EMAIL PROTECTED]> wrote: > > > > My query: > > SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = > > '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND > > c.Candidate_ID = r.Candidate_ID; > > > > Is it possible to do a multiple insert statement like so? > > > > INSERT INTO wow.candidate_erp > > (Candidate_ID, Section_ID, Section_Value) > > INSERT INTO wow.resume_erp > > (Candidate_ID, Vendor_ID, etc.) > > SELECT SQL_CALC_FOUND_ROWS * > > FROM wow.resume r > > INNER JOIN wow.candidate c; > > > > Or do I have to break out the INSERT statements seperately? > > > > Thanks! > > - Eve > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >