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
- 6468 Views
- I also Faced
- E-Mail Answers
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
How do I find mysql version in mysql workbench?
What is ISAM?
What is the default port for MySQL Server?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
How do I restore a mysql database?
What are enums used for in mysql?
what is the difference between between and in operators in mysql?
In which language mysql has been written?
How to connect html form to mysql database using php?
Why to use char instead of varchar in the database?
What are date and time data types?
How do I show columns in mysql?
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?
How to load data files into tables with 'mysqlimport'?
How to create table show example
