Query Test

[The Little Guy]

Is there a way to see what would happen if I test a query, basically see how many rows would be affected if I ran the query?

 

so for example:

 

"DELETE FROM tbl WHERE name LIKE '%bob%'"

 

With the above, I just want to see which ones would have been deleted and not actually delete them. How can that be done?

[RussellReal]

sure..

 

instead of

"DELETE FROM tbl WHERE name LIKE '%bob%'"

 

do

"SELECT COUNT(*) As affected_rows FROM tbl WHERE name LIKE '%bob%'"

[The Little Guy]

Thanks!