[Skream]

seems that cache_num_rows doesn't return if there was a affected row or not.

https://pastebin.com/xNFJBQQH

So how I do it?

[Jstylezzz]

If you're using the threaded MySQL plugin by BlueG (R33 and above), you should be able to use cache_affected_rows.