SQL Translator Tool
Reviewed byAnonymouson Thu, 2nd June 2005
Very nice tool which easy to set up and use. Only problem is the "not" query produces an "and" query result. Might be my version of php/mysql though. Here's the generated sql for the not query "SELECT title, description, filetype, docnumber, date FROM docinfo WHERE (title LIKE '%cosca%' OR description LIKE '%cosca%') AND (NOT title LIKE '%perth%' OR description LIKE '%perth%') ORDER BY title"
Also had to remove ";" from the end of the query to make it work in the query line.
Other than that this code has saved a lot of work!