Case insensitivity of like query in MySQL5.7

for example, I like"% R% answer, the query results include not only R, but also r, which is not what I want, I want to be case-sensitive. I guess it has something to do with the proofreading rules of the table. My table uses utf8mb4 encoding, and the proofreading rule is utf8mb4_unicode_ci. (it seems that this proofreading rule does not have a"_ cs" suffix.) . How to solve the problem of asking for help from the great god?
how to write like binary in SQLAlchemy?


use like binary

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1be96a7-469ba.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1be96a7-469ba.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?