- substr: documentation ( source)
- strrpos: documentation ( source)
<?php
$sql = "SELECT assignment_activities.* FROM (assignment_activities) WHERE `iAssignmentId` = '1' ORDER BY assignment_activities.iAssignmentActivityId DESC LIMIT 10";
echo substr($sql, 0, strrpos($sql, "limit"));