Shulou(Shulou.com)05/31 Report--

How to use commas to concatenate strings in MySql? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

For example, in a certain field, it is 1, 2, 3, 4, 5.

How to use it:

The first one, it can be found out by the introduction of 1, 3, 3, 6.

Select * from XXX where FIND_PART_IN_SET ('1, 3, 3, 6, 1, 2, 3, 4, 5')

The second kind, the introduction of 1, 3, 3, 6 can not be found.

Select * from XXX where FIND_ALL_PART_IN_SET ('1, 3, 3, 6, 1, 2, 3, 4, 5')

Function:

The first one: as long as one of them is included, it can be found out.

CREATE DEFINER = `root` @ `% `FUNCTION `NewProc` (str1 text,str2 text) RETURNS textBEGIN # pass in two comma-separated strings to determine whether the second string contains a single DECLARE CURRENTINDEX INT;# current subscript after the first string split DECLARE CURRENTSTR text;DECLARE result int;set result = 0 IF str1 IS NOT NULL AND str1 set CURRENTINDEX = 0 IF str1 IS NOT NULL AND str1 set CURRENTSTR =''; IF str1 IS NOT NULL AND str1! =''THEN SET CURRENTINDEX = LOCATE (',', str1); WHILE CURRENTINDEX > 0 DO SET CURRENTSTR = substring (str1,1,CURRENTINDEX-1) If FIND_IN_SET (CURRENTSTR,str2) THEN set result = 1; end if; SET str1 = substring (str1,CURRENTINDEX+1); SET CURRENTINDEX = LOCATE (',', str1); END WHILE; # pass only one and no comma IF LENGTH (str1) > 0 THEN if FIND_IN_SET (str1,str2) THEN set result = 1; end if; END IF;END IF;RETURN result;END

The second kind: it must be all included before it can be found out.

CREATE DEFINER = `root` @ `% `FUNCTION `NewProc` (str1 text,str2 text) RETURNS textBEGIN # pass in two comma-separated strings to determine whether the second string contains all the single DECLARE CURRENTINDEX INT;# current subscripts after the first string split DECLARE CURRENTSTR text;DECLARE RESULT int;DECLARE TOTALCOUNT int;DECLARE TRUECOUNT int;set RESULT = 0posiset CURRENTINDEX = 0boarSet CURRENTSTR =''; set TOTALCOUNT = 0transferset TRUECOUNT = 0 IF str1 IS NOT NULL AND str1! =''THEN SET CURRENTINDEX = LOCATE (',', str1); WHILE CURRENTINDEX > 0 DO SET TOTALCOUNT = TOTALCOUNT + 1; SET CURRENTSTR = substring (str1,1,CURRENTINDEX-1); if FIND_IN_SET (CURRENTSTR,str2) THEN SET TRUECOUNT = TRUECOUNT + 1; end if; SET str1 = substring (str1,CURRENTINDEX+1); SET CURRENTINDEX = LOCATE (',', str1); END WHILE; # with only one and no comma IF LENGTH (str1) > 0 THEN SET TOTALCOUNT = TOTALCOUNT + 1 If FIND_IN_SET (str1,str2) THEN SET TRUECOUNT = TRUECOUNT + 1; end if; END IF;END IF;IF TOTALCOUNT > 0 AND TRUECOUNT = TOTALCOUNT THEN SET RESULT = 1 position end IF;RETURN result;END; 's answer on how to use comma concatenation strings in MySql is shared here. I hope the above content can be of some help to everyone. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.