Administration/System/Database query

From Lanius CMS Wiki

Lanius CMS gives you the ability to query your database. Queries to the database are made using SQL, so if you know at least basics of SQL, you can run all standard queries in System => Database => Query database page of the administration backend.

Query database page

Write your SQL query into Enter SQL Query field and click on Execute Query button. Otherwise, click on Clear button to remove your query. You do not have to end your query with a semi-colon, as you would normally. The result of the query will be displayed.

Example query:

 SELECT * FROM #__users;

Query database result page

Related pages

Personal tools
Create a book
  • Add wiki page
  • Collections help