SELECT with LIKE
suggest changeA _
character in a LIKE
clause pattern matches a single character.
Query
SELECT username FROM users WHERE users LIKE 'admin_';
Result
+----------+
| username |
+----------+
| admin1 |
| admin2 |
| admin- |
| adminA |
+----------+
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents