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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / owais masood
select password from tablename
where (password like "A%" AND length(password) between 8 and
15) OR
(password like "a%" AND length(password) between 8 and 15)
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / sonali
select password from tablename
where password like 'a%'
and length(password) between 8 and 15
Is This Answer Correct ? | 2 Yes | 1 No |
Is mysql same as sql?
How do I quit mysql?
Explain timestamp?
What is processlist in mysql?
What is the difference between mysql and pdo?
How do you create a table in mysql workbench?
What are the indexes in mysql?
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
What are the functions of commit and rollback statements?
Why is it called mysql?
What is general log in mysql?
What is sqlyog?