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 is the usage of regular expressions in mysql?
How to get a list of all tables in a database?
What is foreign key in mysql?
What are the steps involved in query processing?
How many rows can mysql handle?
What is 'mysqlimport'?
How do I start mysql in linux?
What is the datatype of image in mysql?
What is the maximum number of records in mysql table?
What happens if you no create privilege in a database?
How to dump one database for backup.
What is the storage engine for mysql?
How to calculate the difference between two dates?
how can you test for null values in a database? : Mysql dba
What is heap table?