Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 24th, 2012  |  syntax: None  |  size: 0.60 KB  |  hits: 11  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. phpMyAdmin single quote not return result
  2. SELECT * FROM user WHERE phone = 60123456789
  3.        
  4. SELECT * FROM user WHERE phone = '60123456789'
  5.        
  6. SELECT * FROM user WHERE phone like '60123456789%'
  7.        
  8. update user set phone = replace(phone, ' ', '')
  9.        
  10. '123  '
  11.        
  12. '  123'
  13.        
  14. SELECT * FROM user WHERE phone = 60123456789
  15.  
  16. SELECT * FROM user WHERE phone = '60123456789'
  17.        
  18. SELECT *
  19. FROM  `tbl_practice`
  20. WHERE  `name` =  '+5734563656546'
  21. LIMIT 0 , 30
  22.  
  23. SELECT *
  24. FROM  `tbl_practice`
  25. WHERE  `name` =  +5734563656546
  26. LIMIT 0 , 30
  27.  
  28.  
  29. SELECT *
  30. FROM  `tbl_practice`
  31. WHERE  `name` =  5734563656546
  32. LIMIT 0 , 30
create a new version of this paste RAW Paste Data