Two methods for determining whether a Mysql string contains a string

Suppose there is a table: CREATETABLEusers (idint (6) NOTNULLAUTO_INCREMENT, PRIMARYKEY (id), user_nameVARCHAR (20) NOTNULL, emailsVARCHAR (50) NOTNULL); initialize the table and add some records. TruncatetableusersINSERTINTOusers (user_name, emails) VALUES (John

Suppose there is a TABLE: create table users (id int (6) not null AUTO_INCREMENT, primary key (id), user_name VARCHAR (20) not null, emails VARCHAR (50) not null); initialize the table and add some records. Truncate table users insert into users (user_name, emails) VALUES ('small Zhang

Suppose there is a table:

Create table users (id int (6) not null AUTO_INCREMENT, primary key (id), user_name VARCHAR (20) not null, emails VARCHAR (50) not null );

Initialize the table and add some records.

Truncate table users
Insert into users (user_name, emails) VALUES ('login', 'a @ email.com, B @email.com, c@email.com ');
Insert into users (user_name, emails) VALUES ('King', 'aa @ email.com, bb@email.com, cc@email.com ');

　　

In Mysql, some fields are of the string type. How do I find records containing some characters?

Method 1:

SELECT * FROM users WHERE emails like "% B @email.com % ";

So the bb@email.com user also found out, not in line with expectations.

Method 2:

Use the mysql string function find_in_set ();

SELECT * FROM users WHERE find_in_set ('aa @ email.com ', emails );

　　

This is acceptable. How can this problem be solved?

Mysql has many string functions: find_in_set (str1, str2) returns the index of the position of str1 in str2. str2 must be separated by commas.

E.g.

Mysql> SELECT find_in_set () ('B', 'a, a, B, c, D') as test;
-> 3