Question SQL Query to show individuals Birth Date

Does anyone knows the SQL Statement to show the birthdate of an individual ?
SELECT * FROM `wt_individuals` i shows the i_gedcom info, but how to extract the date of birth from that whole textblock into a single column ?

Any help is appreciated

Extracting it from wt_individuals is indeed near impossible.

There is another table `wt_dates` which is used for quick access. This contains all dates, so take int account there can be a baptism or christening. You could select the smallest per individual (select min(..) group by ...) and assume it's the date of birth.

NB: query only! Any update should be done with the regular webtrees GUI, otherwise you can easily get data corruption.