Jyxtt701a columns have countless product code, each product contains attributes differ, have the same properties, also have different, anyway may each different, may also have the same, but there are hundreds of species attributes,
Is there any way you can language sentence out, all attribute contains cost and pray?
Such as have all the product cost, contains A attribute, and
Have contain B properties such as the cost of all of the products,, and
Have included C properties such as the cost of all of the products,, and
Etc.,

CodePudding user response:

CodePudding user response:

https://user.qzone.qq.com/1911508146? ADUIN=1911508146 & amp; ADSESSION=1530270443 & amp; ADTAG=CLIENT. QQ. 5563 _mytip. 0 & amp; ADPUBNO=26785 & amp; Source=namecardhoverstar

CodePudding user response:

Select count (*) from the test like '% A %'?

CodePudding user response:

Directly in the like + analysis function is not accurate, such as the BBA identified as A, or want to change my in polymerization,
Methods with the same
https://bbs.csdn.net/topics/392400417? Page=1 # post - 403325458

CodePudding user response:

Can consider to use regular expressions

CodePudding user response:

Or transfer line column, write a function, the property transfer

CodePudding user response:

With the LIKE can also, such as the LIKE 'A; % % 'OR the LIKE; A; % % 'OR the LIKE; A %
Not very in favor of this kind of writing

CodePudding user response:

Build a property sheet, and the associated cost table statistics, just feel like efficiency is not high, because the way you attribute stored