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
- 6462 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 is mysql community server?
What is difference between unix timestamp and mysql timestamp?
Explain triggers and stored procedures?
What is the hostname for mysql database?
What is the purpose of using timestamp data type?
What are the steps required to view your mysql database?
What command is used to delete the data from the table without deleting the table structure?
How to create a trigger in mysql?
How do I create a mysql database?
How do I enable mysqli extension?
How do you name a table?
What is longblob in mysql?
What are views in mysql?
How to get nth highest salary from table in a mysql?
What is the purpose of mysql database?
