Boolean to SQL Query Translator

Visit Publisher Site
Boolean to SQL Query Translator Hosting Promo

Sponsored by TMDHosting

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.

Visit publisher site: Boolean to SQL Query Translator
  • Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
    Rated 4.17 out of 5 (4 ratings)
  • 1 Member Reviews
  • Views: 1,397
  • Price: Free

Listing Details

Version:
1.0 
Filed in:
Scripts / PHP / Scripts & Programs / Database Tools
Submitted on:
 
Last Updated:
Feb 11, 2009 
Publisher:
Other listings by this publisher

License & Pricing Information

LICENSE #1
License Type:
Free Non-Commercial
Price:
$0.00 USD
Additional Info:
LICENSE #2
License Type:
Free Non-Commercial
Price:
$0.00 USD
Additional Info:

Featured Marketplace Listings

User Reviews 

Add/Edit Your Review
Average Member Rating: 4.17/5

Displaying 1-1 out of 1 reviews

  • 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!

See all 1 reviews for Boolean to SQL Query Translator