Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. you want:
  2.  
  3. SELECT * from `actionlog` WHERE (`username` LIKE 'ry%' OR `address` LIKE 'ry%' OR `action` LIKE '%ry%' OR `datetime` LIKE '%ry%') AND `username` != 'cron@localhost' ORDER BY `datetime` DESC LIMIT 0,25
  4.  
  5. yours is currently like:
  6.  
  7. SELECT * from `actionlog` WHERE `username` LIKE 'ry%' OR `address` LIKE 'ry%' OR `action` LIKE '%ry%' OR (`datetime` LIKE '%ry%' AND `username` != 'cron@localhost') ORDER BY `datetime` DESC LIMIT 0,25
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement