UPDATE a range of records??

In the following code, I am trying to update a range of sql records with LIMIT $xx, $yy. Everything works in this code except this limit parameter. I tried using differenct sql syntax but no luck.

Can you help?????


$sql = "UPDATE $usertable SET TimesViewed=TimesViewed+1 WHERE $classiccycles LIKE '%$search%'".
" AND ClassifiedType='$ClassifiedType' AND LIMIT $xx, $yy";

Starting in version 3.23 of mysql, you can use a limit clause. But, it is not the same syntax as the select limit clause. You can only specify the number of rows that should be affected.

See the very end of this page:

http://www.mysql.com/doc/en/UPDATE.html