Query to get Elements from DB

Hi every one,

i would like know if exist a query or SP for get all Elements in MySQL.

regards
SO

You just want the Elements (the fields, not any values)? They’re in a table of their own… for any table you can call findAll to get all the records from the table:

get_db()->getTable('Element')->findAll();