SQL statements, in rencent a group of fifty people, there are 60 people in rencent two groups, in rencent 80 people in three groups, paddy fields village, a group of about 60 people, paddy fields village, two group of 50 people, how to make in rencent 123 groups in rencent,
Paddy fields village village two groups into paddy fields

CodePudding user response:

 
='in rencent' update table name set fields where fields like 'in rencent %'; 
Update table name set field='village of paddy fields where fields like' % 'paddy fields village; 

CodePudding user response:

reference 1st floor qq_41622282 response:

 
='in rencent' update table name set fields where fields like 'in rencent %'; 
Update table name set field='village of paddy fields where fields like' % 'paddy fields village; 

If there are thousands of this

CodePudding user response:

If the name of the village are fixed three can use the substr intercepted before if not can use instr try you'll have to find the common points of data

CodePudding user response:

reference qq_41622282 reply: 3/f

if the name of the village are fixed three can use the substr intercepted before if not can use instr try you'll have to find common points data

Is there any method to extract all the villagers only the location of the village of the first word?

CodePudding user response:

It is ok to can be in the instr designated specific usage can baidu character will return to you the character location, then you according to the interception

CodePudding user response:

Before you in my example to just write the three red box respectively corresponding to the three parameters of the substr you see is what you need