has the title say, i wonder if anyone of you out there, can help me with a query,, to calculate the age from dob and added to my table, that has already a column called 'AGE'

don't store something such as age in a table, its derived data, and should be derived as and when required.

Age is a particularly good example of why you don't store derived data, as effectively you would have to run this query every night to keep the value of age up to date

mysql calculate age - Google Search

mysql calculate age - Google Search