That is probably mean
I have a list
The table name abc_biao
Need to query the field content
If content field exists some value
So give leixing field is inserted into the specified value
To insert query vidqq field out the value of the

Again a little bit popular

Abc_biao fuzzy query the content when the content & amp; amp; Auto=0 & amp; amp; Vid=DDDDDDD value when the DDDDDDD preach to qqvid fields at the same time assigned to leixing field qqvid values






The final look like



Because there is no planning before, so now need to MySQL database to execute the SQL statement to update the value

This did not get, what a great god do me a favor, OK exceptional

CodePudding user response:

Wait for a great god

CodePudding user response:

there is no hope

CodePudding user response:

The UPDATE abc_biao
SET qqvid=DDDDDDD, leixing='DDDDDDD'
WHERE the content LIKE '% DDDDDDD %'

CodePudding user response:

The

reference 3 floor 丿 reply: three years

UPDATE abc_biao
SET qqvid=DDDDDDD, leixing='DDDDDDD'
WHERE the content LIKE '% DDDDDDD %

Is possible, I try to wait for people, such as a day for

CodePudding user response:

The

reference 3 floor 丿 reply: three years

UPDATE abc_biao
SET qqvid=DDDDDDD, leixing='DDDDDDD'
WHERE the content LIKE '% DDDDDDD %

I have made the wrong expression, this value is not fixed, is also doing phase

Is actually a lookup table if there is the value for the value and then pass this VID

CodePudding user response:

reference 5 floor weixin_46952374 reply:

Quote: refer to the third floor three years 丿 response:

The UPDATE abc_biao
SET qqvid=DDDDDDD, leixing='DDDDDDD'
WHERE the content LIKE '% DDDDDDD %

I have made the wrong expression, this value is not fixed, is also doing phase

Is actually a lookup table if there is the value for the value and then pass this VID

Determine the value to a fixed leixing fields is OK, mainly the value behind the don't know how to get this vid, I mainly need is behind this vid value passed to the video vid fields,

CodePudding user response:

Used to such access can be:

 DECLARE @ SRC NVARCHAR (MAX) 
SET @ SRC="https://v.qq.com/iframe/player.html? Vid=y3060o89toh '

SELECT SUBSTRING (@ SRC, CHARINDEX (' vid='@ SRC) + 4200) 
/* 
Y3060o89toh 
*/