数据库查询大小写不区分

mysql> select * from  tab_test where upper(name)='T';

+----+------+

| id | name |

+----+------+

|  1 | T    |

|  2 | t    |

+----+------+

2 rows in set

mysql>