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.
Answer Posted / sonali
select password from tablename
where password like 'a%'
and length(password) between 8 and 15
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Does mysql need a server?
How to delete the repeated records from a table?
What are the difference between and myisam and innodb?
What is mysql in dbms?
What is mysql aggregate functions? Explain
What is the purpose of -> in the mysql terminal?
What are the 'mysql' command line options?
What is the use of innodb in mysql?
How to get current MySQL version?
Is there a way to see the files which are stored?
Where is mysql installed on linux?
What is mysql command line?
What are mysql functions?
Is mysql a database?
How can we get the number of rows affected by query?