Re: [PHP-DB] DISTINCT in SQL query

2001-08-27 Thread Andrey Hristov
OIN your mysqld will fork too much. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: "Scott Mebberson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 27, 2001 9:33 AM Subject: [PHP-DB] DISTINCT in SQL

[PHP-DB] DISTINCT in SQL query

2001-08-26 Thread Scott Mebberson
Hi Guys, I am retriving information based across three tables, here is the SQL statement SELECT DISTINCT title, filelocation, filename, ranking, summary FROM pdf, words, searchwords WHERE words.id = searchwords.word_id AND pdf.id = searchwords.pdf_id AND LCASE(words.word) LIKE LCASE('%$searchstr