Want to hire a development team?
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,929
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
Advertisement The banner below is an advertisement
Quikwit - AI Chatbot Platform

You May Also Like

Cloud Services You May Like

Help/Fix on AWS CloudFront (1 Hour)

One hour of help to configure or fix AWS CloudFront distributions.

Website and database migration to AWS EC2 instance

Migrate your website and database from existing hosting to an AWS EC2 server.

1 Hour AWS Consulting Services/Support

One hour of flexible AWS consulting or support for architecture, design, or issues.

Help/Fix on AWS Auto Scaling (1 Hour)

One hour of help to troubleshoot or fine tune AWS Auto Scaling behaviour.

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