I cannot execute the delete request with LIMIT.

Extra Block Types (EBT) - New Layout Builder experience❗

Extra Block Types (EBT) - styled, customizable block types: Slideshows, Tabs, Cards, Accordions and many others. Built-in settings for background, DOM Box, javascript plugins. Experience the future of layout building today.

Demo EBT modules Download EBT modules

22/02/2025, by Anonymous (not verified)

Forums

Module Development

I cannot execute this code

$query = db_query_range('
DELETE FROM {my_table}
WHERE some_col LIKE :t', 0, $limit, 
array(':t'=>'%delete rows containing this phrase%'))->execute();

It throws a PDO exception
The query looks like this

DELETE FROM my_table
WHERE some_col LIKE '%delete rows containing this phrase%'
LIMIT 0, 5

but MySQL accepts LIMIT 5 but not LIMIT 0, 5

Extra Block Types (EBT) - New Layout Builder experience❗

❗Extra Paragraph Types (EPT) - New Paragraphs experience

I cannot execute the delete request with LIMIT.