Essential Books

SELECT with LIKE

suggest change

A _ 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.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

SELECT:
*SELECT
*SELECT with DISTINCT
*SELECT all columns
*SELECT by column name
*SELECT with LIKE
*SELECT with CASE or IF
*SELECT with Alias AS
*SELECT with a LIMIT clause
*SELECT with WHERE
*SELECT with BETWEEN
*SELECT with LIKE
*SELECT with date range
Table Of Contents