Boolean to SQL Query Translator
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.
Micro Jobs Theme - Setup a website like Fiverr today *New 2022*Sponsored
posted byshopperpressinClone Scripts
PriceUSD 99.00
Views6793
Car Dealer & Autos Theme (New 2022) - Download Now!Sponsored
posted byshopperpressinAutos
PriceUSD 99.00
Views8141
Monitoring Spot Instance Prices and Migrating Instances to Optimal Types/Regions
Automatically monitoring AWS Spot instance prices and moving servers to better instance types or regions for maximum sav
Help/Fix on AWS Kubernetes Service(EKS) (1 Hour)
One hour of help or fixes for Kubernetes clusters running on AWS EKS.
Creating and configuring Private network in AWS and connecting it through VPN
Design and configure a private AWS network and connect it securely with VPN.
AWS Spot Instance / Server Deployment for Cost Reduction
Deploy servers using AWS Spot Instances to significantly cut hosting costs while keeping performance and flexibility for
User Reviews
Please rate the listing and tell the world know what do you think about the listing.
SQL Translator Tool
Reviewed byAnonymousonThu, 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!
