Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What is the usage of regular expressions in mysql?

942


How to get a list of all tables in a database?

1105


What is foreign key in mysql?

1093


What are the steps involved in query processing?

937


How many rows can mysql handle?

991


What is 'mysqlimport'?

983


How do I start mysql in linux?

954


What is the datatype of image in mysql?

970


What is the maximum number of records in mysql table?

975


What happens if you no create privilege in a database?

1179


How to dump one database for backup.

986


What is the storage engine for mysql?

1008


How to calculate the difference between two dates?

1119


how can you test for null values in a database? : Mysql dba

981


What is heap table?

1075