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
- 6304 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
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
What is a tinyint in mysql?
How do I clear the command in mysql?
What is a user defined variable?
What is database engine in mysql?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
Is mysql easy to learn?
What is mysql optimization?
Why we use mongodb instead of mysql?
Why use stored procedures in mysql?
What tools available for managing mysql server?
How do I connect to a mysql database?
How do I show users in mysql?
