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