如何在mysql中搜索确切的字符串 [英] how to search for exact string in mysql

问题描述

我正在尝试在mysql中搜索字符串的完全匹配.字符串为"nrew".但是当我执行下面的查询时，我仍然得到结果:

I'm trying to search for an exact match of a string in mysql. The string is 'nrew'. But when I do the queries below, I still get a result:

SELECT UserID FROM sys_users WHERE UserID='NREW'
SELECT UserID FROM sys_users WHERE UserID='NrEw'

请帮助.

推荐答案

SELECT UserID FROM sys_users WHERE BINARY UserID='NREW'

这篇关于如何在mysql中搜索确切的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！