æ¹æ³ä¸ï¼
å¯ä»¥ç¨%æ¥å®ç°
SELECT * FROM users WHERE emails like "%
[email protected]%";
ä½æ¯è¿æ ·åçè¯å°±ä¼æ
[email protected]ä¹æ¥åºæ¥äºå°±ä¸ç¬¦åéæ±äº
æ¹æ³äºï¼
å©ç¨mysql å符串å½æ° find_in_set();
SELECT * FROM users WHERE find_in_set('
[email protected]', emails);
è¿æ ·åå°±å¯ä»¥æ¾å°emailå段éå
å«æ
[email protected]çææç¨æ·äº
è¦æ³¨æçæ¯ï¼mysqlå符串å½æ° find_in_set(str1,str2)å½æ°æ¯è¿åstr2ä¸str1æå¨çä½ç½®ç´¢å¼ï¼str2å¿
须以","åå²å¼ã