How can I make SQL Query case sensitive string comparison on MySQL?

In Websites we display the data which fetch from database using string based conditions.
OR
Login Feature / Change password Featured based on string based conditions.
OR
Show the user detils behalf on user slug like "http://example.com/users/user-slug-value"

If you want to make your SQL Query as case sensitive, We have following 3 ways.

1. Do at MySQL Server Level
   Set Following in /etc/mysql/my.cnf (Works for >MySQL 5.5 only)

   character-set-server=utf8
   collation-server=utf8_bin

2. Set the column as Case sensitive,For Example
   

   ALTER TABLE `users` CHANGE `name` `name` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;

3. Set the Query as case sensitive, For Example
   

   SELECT *  FROM `users` WHERE BINARY `name` = 'raJ'

Best Related Posts are Following:

1. DBMS Interview Questions and Answers for Freshers.
2. MySQL Interview Questions and Answers for Experienced.
3. Difference between inner join and outer join in MySQL.
4. How to get a list of MySQL user accounts?.
5. How to delete MySQL Binary logs Files in Wamp Server?.
6. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
7. Multiple column ordering in Zend Framework.
8. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
9. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
10. Difference Between MyISAM and innoDB - MySQL.
11. MySQL Functions - MySQL tutorial for beginners.
12. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
13. Mysql FullText Search Examples.
14. MySQL Constraint Example.
15. MySQL Cascade Example.
16. Mysql-Group-Concat.
17. MySQL Expressions.
18. MySQL Delete Table Example.
19. Replace Table - Update Field, Move Records to another table MySQL.
20. mysql insert syntax - Add records from another table - Copy Table from one table to another.
21. Mysql Update Syntax - Update Multiple Records.
22. What is Mysql.
23. Mysql Console Commands - Export and Import database from command line.
24. MySQL interview Questions and Answers For Experienced.

How to Make Website Responsive for mobile devices?

Question: Why Responsive Web Design is the compulsary for websites?

1. Recommended By Google: Google have higher Preference for Responsive design as compare to Non-Responsive.
2. One Website, Many Devices: Single website can be viewable in desktop, laptop, ipad, different sizes of mobile.
3. Good for SEO
4. Responsive Website have more page views as compare to non-responsive.
5. It looks always better in different resolution.

Question: How to check website is responsive OR Not?
https://www.google.com/webmasters/tools/mobile-friendly/


Question: How can i make a existing website responsive?
You can make any website responsive. Just follow the simple steps.

1. Add Following code in head tag.
   <meta name="viewport" content="width=device-width, initial-scale=1.0">
2. Create a responsive.css file and include in all the pages.
3. Add Following code in responsive.css

   /* Smaller Resolution Desktops and Laptops */
   @media (max-width: 800px) {
          
          
   }
   /* Smaller devices like Ipad*/
   @media (max-width: 650px) {
   
          
   }
   /* Even Smaller devices like Mobile*/
   @media (max-width: 450px) {
   
          
   }
   /* Smallest Mobile devices */
   @media only screen and (min-device-width: 300px) and (max-device-width: 480px) {
          
          
   }

4. Now structure is ready, you just need to add css according to devices.
5. Note: In Responsive design you need to hide extra information of websit

Best Related Posts are Following:

1. CSS3 interview questions and answers for experienced.
2. CSS Interview Questions and Answers.