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
What does mysql flush privileges do?
What do you understand by mysql terminal?
How can we encrypt and decrypt a data presented in a table using mysql?
What is trigger in mysql with example?
What is clob in mysql
How do I automate a backup in mysql?
How to store binary data in mysql?
List some comparisons operators used in mysql?
What is the use of mysqli_query?
What is mysqli_select_db?
How to use case expression?
How to calculate the difference between two dates?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
Can mysql handle billions of records?
Write a command with which mysql table can be repaired