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.
Themeforest Clone Script - Digi MonsterSponsored
posted bySangvishinClone Scripts
PriceUSD 499.00
Views3267
Microsoft Azure App Service Deployment & Web Application Configuration
Deploy and configure Azure App Service for hosting web applications with secure access, performance tuning, and environm
1 Hour AWS Consulting Services/Support
One hour of flexible AWS consulting or support for architecture, design, or issues.
Management of Shared Storage Using AWS EFS
Setting up and managing a shared disk/folder using AWS EFS so multiple servers can access the same data at the same time
Help/Fix on AWS Lambda Service (1 Hour)
One hour of help or fixes for AWS Lambda functions and related services.
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!