No Images Added Yet

Boolean to SQL Query Translator

Rated4.2/5 (4 ratings)
Add to Favorites
Publisher
This is a translation function to convert boolean search syntax into a SQL Query.
Product Details

This is a function to convert a user's query in boolean syntax ("hotels AND mexico NOT cockroaches) into a SQL query over the appropriate database fields.

Report this Listing
Price
Free
Licence Type
Free
Views
1,575
Submitted on
29th May 2005
Last Updated
11th February 2009
Licence Type
Free Non-Commercial
License Price
USD 0
Licence Type
Free Non-Commercial
License Price
USD 0

You May Also Like

User Reviews

Please rate the listing and tell the world know what do you think about the listing.
(4 ratings)
Average User Rating: 4.2/5
SQL Translator Tool
Reviewed byAnonymousonThu, 2nd June 2005
Rating 4 - Very Good
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!
Displaying 1-1 out of 1 reviews
View All Reviews