SELECT Password FROM tablename WHERE Password LIKE 'A%' AND Le

Query to select passwords from a table having a column
"Password" Whose length is b/w 8 &15 and having 'A' as the
first character in the password irrespective of case.

Question Posted / mdeva

3 Answers
6419 Views
I also Faced
E-Mail Answers

Answer Posted / mdeva

SELECT Password
FROM tablename
WHERE Password LIKE 'A%'
AND Length( Password) >=8
AND Length( Password) <=15

Is This Answer Correct ?

15 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you flush privileges?

952

What is mvcc in mysql?

976

What are the differences between char and varchar?

1086

What is difference between mysql and mysqli?

901

Is pdo faster than mysqli?

877

What is the limit of mysql database?

942

Is oracle mysql free?

856

In mysql, what is joins? Explain

954

How many triggers are possible in mysql?

960

How do I export mysql query results to excel?

957

What are the advantages of a procedure?

905

What is a result set object?

936

What is the query to display top 20 rows?

1006

how to take mysql database backup?

1053

Describe mysql transaction properties.

1004