Why read only part of it when the meta character is in front of it?

a-f

my question is why only the previous part is read, and the latter part is no longer matched. Does it not match all the strings in aMuf?

Apr.02,2022

there are no characters in the range of Amurf in the remaining characters, so it doesn't match

.
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-1e99cd2-4ec55.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-1e99cd2-4ec55.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?