Want to hire a development team?
No Images Added Yet

Boolean to SQL Query Translator

Rated4.2/5 (4 ratings)
Add to Favorites
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
Licence Type
Submitted on
29th May 2005
Last Updated
11th February 2009
Licence Type
Free Non-Commercial
License Price
Licence Type
Free Non-Commercial
License Price

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