Question

Which SQL statement will search for two or three consecutive 'r' characters in the comments field of the message table?
1. SELECT * FROM message WHERE comments LIKE '%rr%' OR comments LIKE '%rrr%';
2. SELECT * FROM message WHERE comments REGEXP 'rr|r{3}';
3. SELECT * FROM message WHERE comments LIKE '%r%r%r%';
4. SELECT * FROM message WHERE comments REGEXP 'r{2,3}';