PHP remove LIMIT from MySQL query. If the query is automatically limit to so much rows and you want to prevent the tool from imposing this limit or you just want to totally delete it. Here’s a simple code to do it.
Removing LIMIT from MySQL query:
$pattern = '/LIMIT.\d/';
preg_match($pattern, $query, $matches);
$query = str_replace($matches[0], '', $query);
preg_match($pattern, $query, $matches);
$query = str_replace($matches[0], '', $query);