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
- 6465 Views
- I also Faced
- E-Mail Answers
Answer Posted / mdeva
SELECT Password
FROM tablename
WHERE Password LIKE 'A%'
AND Length( Password) >=8
AND Length( Password) <=15
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
Do while loop in mysql procedure?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
What is difference between inner vs self vs cross?
How Switch (select or use) to a database.
Where is mysql data stored linux?
What are the technical features of MySQL?
How to create trigger in mysql phpmyadmin?
What is the difference between unix timestamps and mysql timestamps?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
How do I restart mysql on windows?
How to enter numeric values as hex numbers?
What are the objects can be created using CREATE statement?
What are ddl statements in mysql?
What is mvcc in mysql?
What is database clustering in mysql?
