Sunday, 15 May 2011

mysql - Select query without exact match using % Wildcard -


Hello, I have solved almost one problem and I need help using this code 

 Select  Select from the new products (where the old product from the old products of the product, like old products, new products like productivity). New product is to be selected).  
 While the product ID varchar is like '91 or 91b ', then it is not only in both tables, only when  Precise  Varchar.  
 I tried to do something like (% ProductID%) by doing it:  
  Where old products Like productivity ('%' + new_products.ProductID + '%')  
 
 Although the results are not working at all, it recognizes the item which is unique as both On the contrary. Any help?

Your expression in MySQL ('%' + new_products.ProductID + '%') Perhaps instead Try: 

  CONCAT ('%', new_products.ProductID, '%')

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)