We can use Joomla's <code>replacePrefix</code> function which dumps out the query in a format that can be inserted straight into the likes of phpMyAdmin.
Here's a simple example:
 $db = JFactory::getDbo();
 $query = $db-&gt;getQuery(true);
 $query-&gt;select($db-&gt;quoteName('title'))
 -&gt;from($db-&gt;quoteName('#__content'));
 $db-&gt;setQuery($query);
 // Dump the query
 echo $db-&gt;replacePrefix((string) $query);
Will output the following:
 SELECT <code>title</code> FROM <code>jos_content</code>

We can use Joomla's `replacePrefix` function which dumps out the query in a format that can be inserted straight into the likes of phpMyAdmin.

Here's a simple example:

    $db = JFactory::getDbo();
    
    $query = $db->getQuery(true);
    $query->select($db->quoteName('title'))
          ->from($db->quoteName('#__content'));
    $db->setQuery($query);
    
    // Dump the query
    echo $db->replacePrefix((string) $query);
    

Will output the following:

    SELECT `title` FROM `jos_content`

Daniel Felix

Daniel Felix

Print the raw query from dbo for debugging Joomla