a guest Jan 22nd, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT *
- FROM users
- where `username` like "%abc%"
- or `name` like "%abc%"
- or `email` like "%abc%"
- SELECT * from users where abc REGEXP 'username|name|email';
- SELECT * from users where CONCAT(username, ',', name, ',', email) REGEXP 'abc'
RAW Paste Data