Guest User

Untitled

a guest
Jan 19th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. options value is 10,15,20,15,25,10
  2.  
  3. options value should be 10,15,20,25
  4.  
  5. $duplicateValues = explode(',',$sqlResult);
  6. $duplicateValues= array_unique($duplicateValues);
  7.  
  8. SUBSTRING_INDEX(str, delim, count)
  9.  
  10. INSTR (ori_str, sub_str)
  11.  
  12. POSITION(substr IN str)
  13.  
  14. select * from Order join numbers on char_length(options) - char_length(replace(options, ',', '')) >= n - 1
Add Comment
Please, Sign In to add comment