Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 6593 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What's new in mysql 8?
What is the storage engine for mysql?
What are the advantages of MySQL when compared with Oracle?
Write a query to create a database and a table?
How do I connect to mysql database?
How to calculate expressions with sql statements?
How do I tune a mysql query?
Can mysql scale horizontally?
How can you plan the logshipping before processing?
How can I see connections in mysql?
What is pragma autonomous_transaction?
What is longblob in mysql?
What is the difference between mysql_connect and mysqli_connect?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
What is the difference between b-tree and hash indexes?
