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
6589 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 to represent ENUMs and SETs internally?

1162

What is triggers?

1006

Write a query to stop mysql in unix

1093

What is msql?

1049

What is a join in mysql?

954

How many sql dml commands are supported by 'mysql'?

1023

What is the data type for file in mysql?

1025

What is mysqli_result?

982

How would you enter characters as hex numbers?

986

What is 1nf 2nf 3nf?

1031

How do I select a database in mysql workbench?

1080

Is mysqli faster than mysql?

981

Which is better mysql or mssql?

976

Restore database (or database table) from backup.

1068

What are the advantages of MySQL when compared with Oracle?

979