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
- 6424 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
Why is the basic difference between left join, right join and inner join?
How to use count function in mysql?
What are the differences between a primary key and foreign key?
What is difference between microsoft sql and mysql?
In how many ways we can retrieve data in the result set of mysql using php?
How can you calculate the sum of any column of a table?
Can you shard mysql?
What is dump in mysql?
What is the difference between mysql and oracle?
How do I start and stop mysql server?
What is trigger in mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
what is the procedure to configure the application of mysql?
What are the technical specifications of mysql?
how to take mysql database backup?
