A
A
Artur Yalaltdinov2015-01-21 00:21:29
PHP
Artur Yalaltdinov, 2015-01-21 00:21:29

How to make a SQL query?

In the table, some users have a Number field consisting of 4 digits or more, how to execute a query so that to display users who have 4 digits in the Number field?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
I
IceJOKER, 2015-01-21
@crazy_str

select * from users where CHAR_LENGTH(Number) = 4;
wonders of google)

E
esy1993, 2015-01-21
@esy1993

www.mysql.ru/docs/gruber
Something like SQL for dummies

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question