i want to generate a query
example:
if the english question s given
->list all the details from my_table where name='smith' and age <30
it shld generate a mysql query for the question
->SELECT * FROM my_table WHERE name = 'Smith AND age < 30;
krish_kooll 0 Newbie Poster
RoryGren 2 Junior Poster in Training
I don't think you will be able to do that from mySQL.
What scripting / programming language are you going to use?
krish_kooll 0 Newbie Poster
using java... something like querybrowser
RoryGren 2 Junior Poster in Training
I suggest you post your question on the Java forum. You'll probably get better help there
blater 2 Light Poster
It's a difficult problem, but if you limit the vocabulary that can be used it's doable. Check out http://www.markwatson.com/opensource/#nlbean for an example implementation in Java.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.