Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT u.*
- FROM user u
- WHERE 'Kenneth Varg' LIKE Concat(Concat('%',u.first_name),'%')
- OR 'Kenneth Varg' LIKE Concat(Concat('%',u.last_name),'%');
- SELECT *
- FROM user
- WHERE first_name LIKE '%Ken%'
- OR last_name LIKE '%Ken%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement