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.
Auction Theme: Start your own auction website today. (New 2022) - Download Now!Sponsored
posted byshopperpressinAuctions
PriceUSD 99.00
Views5877
Inout RealEstate - Map Based Advanced Real Estate PortalSponsored
posted byinoutscriptsinReal Estate
PriceUSD 499.00
Views8531
Cloudflare Ongoing Management & Monitoring (Monthly)
Monthly Cloudflare management including policy changes, monitoring, tuning and issue response.
Configure EC2 Auto Scaling
Setting up EC2 Auto Scaling to automatically adjust the number of servers based on traffic, performance, and demand.
Help/Fix on identifying the most cost effective AWS spot instances based on instance type and region (1 Hour)
One hour of help to choose the most cost effective AWS Spot instances for your workload.
Cost optimization by archiving standard AWS snapshots
Reduce storage costs by cleaning up and archiving old EC2 or EBS snapshots safely.
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!