| select user_id, user_name from user
where user_name like '%bot%'
COLLATE... |
2 years ago |
| select user_id, user_name from user
where UPPER(user_name) like... |
2 years ago |
| select user_id, user_name from user
where UPPER(user_name) like '%BOT%'
limit 50; |
2 years ago |
| select user_id, user_name from user
where LCASE(user_name) like '%bot%' and... |
2 years ago |
| select user_id, user_name from user
where LOWER(user_name) like '%bot%' and... |
2 years ago |
| select user_id, user_name from user
where BINARY user_name like '%bot%' and... |
2 years ago |
| select user_id, user_name from user
where user_name like '%Bot%' and... |
2 years ago |
| select user_id, user_name from user
where user_name like '%Bot%'
limit 50; |
2 years ago |
| select user_name from user
where user_name like '%bot%'
limit 50; |
2 years ago |
| select user_name from user
where user_name is like '%bot%'
limit 50; |
2 years ago |
