Sql_ Condition Range Query

Select *  fromStudentswhereEnglishname like '[c-r]%'--Query the record of the Englishname field beginning with the letter ' C '-' r 'Select *  fromStudentswhereEnglishname like '[cr]%'--Query the record where the Englishname field begins with a letter between ' C ' or ' r 'Select *  fromStudentswhereEnglishname like '%100/%%' Escape '/' --query for records containing ' 100% ' in the Englishname field--query englishname,name,classname any field containing ' G ', ' j ', ' K ' RecordsSelect *  fromStudentswhereEnglishname+Name+ClassName like '%[gjk]%' --The square brackets mean that you can match any character in the brackets

Sql_ Condition Range Query