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
- 6306 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
Is sql and mysql same?
Can't connect mysql server on localhost?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
what is the default port for mysql server? : Mysql dba
What is a trigger in mysql?
How do I start mysql in ubuntu?
What are the 'mysql' command line arguments?
Explain timestamp?
Why use stored procedures in mysql?
What is processlist in mysql?
What is difference between schema and table?
What are the 3 main types of search queries?
Why MySQL is used?
How do I install mysql on windows 10?
Is there a free version of mysql?
