例子 - like “fa”

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,age FROM test_isolation.user where firstname like "fa"

  
  

例子 - right like “%”

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age

• idx_aliasname_unique

  select firstname FROM test_isolation.user where firstname like "fa%"

  
  

  例子 - left like “%”

• idx_firstname

• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname FROM test_isolation.user where firstname like "%fa"