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

Does mysql need a server?

908


How to delete the repeated records from a table?

954


What are the difference between and myisam and innodb?

1002


What is mysql in dbms?

998


What is mysql aggregate functions? Explain

1061


What is the purpose of -> in the mysql terminal?

1094


What are the 'mysql' command line options?

966


What is the use of innodb in mysql?

963


How to get current MySQL version?

1065


Is there a way to see the files which are stored?

954


Where is mysql installed on linux?

900


What is mysql command line?

1024


What are mysql functions?

930


Is mysql a database?

927


How can we get the number of rows affected by query?

1037