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 does mysql flush privileges do?

880


What do you understand by mysql terminal?

984


How can we encrypt and decrypt a data presented in a table using mysql?

970


What is trigger in mysql with example?

864


What is clob in mysql

888


How do I automate a backup in mysql?

919


How to store binary data in mysql?

956


List some comparisons operators used in mysql?

934


What is the use of mysqli_query?

835


What is mysqli_select_db?

914


How to use case expression?

900


How to calculate the difference between two dates?

977


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

954


Can mysql handle billions of records?

966


Write a command with which mysql table can be repaired

886