how to generate a mysql query from a english question
 

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;

Re: how to generate a mysql query from a english question
 

I don't think you will be able to do that from mySQL.

What scripting / programming language are you going to use?

Re: how to generate a mysql query from a english question
 

using java... something like querybrowser

Re: how to generate a mysql query from a english question
 

I suggest you post your question on the Java forum. You'll probably get better help there

Re: how to generate a mysql query from a english question
 

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.