Novice for help, as shown in figure I want contain '4', but don't contain as' 34 ', '47', '48', '144', '444' data how write SQL statements, such as

SELECT cid FROM JDGJ. Xa_shop_product_data where cid like '% 4%'

CodePudding user response:

And not like '% 34%' and not like '% 47%' and...

CodePudding user response:

Filter can be taken out after their applications,

CodePudding user response:

SELECT cid FROM JDGJ. Xa_shop_product_data where cid like '% %. 4.'

CodePudding user response:

You are unable to handle the SQL statement to estimate.

CodePudding user response:

% 4% all found out, the code loop check him again

CodePudding user response:

 SELECT cid FROM JDGJ. Xa_shop_product_data where ' '+ cid +'. 'like' % %. 4. '

CodePudding user response:

Of this and find out 4 to check the filter