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
- 6339 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
Which statement is used to delete a table in MySQL.
How do I create a database in mysql workbench?
What is 'mysqladmin' in mysql?
Where’s database data actually stored?
What is insert query in mysql?
How to use case expression?
What is a query in mysql?
Is mysql good for big data?
What is difference between pdo and mysqli?
What is view in mysql?
What is a scalar function?
What is difference between unix timestamp and mysql timestamp?
Restore database (or database table) from backup.
How we can get distinct columns values in mysql?
What is ISAM?
