Code: Select all
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('email');
$query->from($db->quoteName('#__com_registrants'));
$query->where($db->quoteName('email') . " = " . $db->quote('[email protected]'));
// Reset the query using our newly populated query object.
$db->setQuery($query);
// Load the results as a list of stdClass objects (see later for more options on retrieving data).
$results = $db->loadObjectList();
print_r($results);
Code: Select all
$query->where($db->quoteName('email') . " LIKE " . $db->quote(''\'gmail.com%\'''));