Using MijoSQL

yellowwebmonkey web services

Install the MijoSQL Free component to your site https://mijosoft.com/downloads/mijosql/mijosql-free

In the backend of your site go to Components>>MijoSQL>>Run Query

SQL

Select the table that has the information you want to query for this example we are going to query all the users on the site 

SQL1

Change the limit of query results as desired the default is 10.

SQL2

Select Run Query

SQL2.5

All of the users will apper here

SQL3

If you want to export this listig to a CSV.  Select “Export to CSV” and it will auto download to your computer.

SQL4

 

About YellowWebMonkey

YellowWebMonkey Web design offers reliable website design, SEO and digital marketing services for Joomla, WordPress and Shopify sites. We strive to be a one-stop shop for all your web needs.

Recent Posts

Follow Us