Skip to main content

AND & OR Syntax for SELECT Query in Mysql

AND & OR Syntax in Select Query can be used to filter the data from table column with multiple choices.

AND Syntax will show results only when both conditions are true but
OR  Syntax will show results even when one condition is true.

Example Table : For your reference


table_name
Column_name1Column_name2Column_name3Column_name4
1MalearticlesSam
2FemaledatabaseSam
3MalecodingJam
4MalecodingKam
5FemalecodingJam

Table Name is : table_name

AND Syntax Example

Query : "SELECT * from table_name WHERE Column_name3='articles' AND Column_name4='Sam'"

If you execute the above query then the first record will appear 


table_name
Column_name1 Column_name2 Column_name3 Column_name4
1 Male articles Sam


OR Syntax Example

Query : "SELECT *  from table_name WHERE Column_name3='articles' OR Column_name3='coding'"

If you execute the above query then the records which contains coding and articles from column_name3 will be displayed



table_name
Column_name1 Column_name2 Column_name3 Column_name4
1 Male articles Sam
3 Male coding Jam
4 Male coding Kam
5 Female coding Jam


AND & OR Syntax Example


Query : "SELECT *  from table_name WHERE Column_name4='Sam' AND (Column_name3='articles' OR Column_name3='coding') "


If you execute the above query then its mandatory to have Column_name4 with Sam data but for Column_name3 can have articles or coding

table_name
Column_name1 Column_name2 Column_name3 Column_name4
1 Male articles Sam

Comments

Popular posts from this blog

Connect To JioFi Device Without Knowing The Passwords Using WPS

If someone in your home or your friends are using Jiofi device and he/she is not sharing the password with you then i am going to share you a simple trick, so you can easily connect to the jiofi router without the need of password and start using the unlimited internet.

This trick can be achieved using the WPS technology (Wi-Fi Protected Setup; originally, Wi-Fi Simple Config) is a network security standard to create a secure wireless home network.

Follow the steps to get the internet for free using the "WPS Push Button Method"
Go to your Wifi Settings in your smartphone device like Android Turn on your Wifi Click the option button and select the  "WPS push button" and you will be seeing the popup window like this below picture.
Now take your JioFi Device and in the right side, you will seeing the WPS button  Hold the WPS button for few moments and see the Jiofi display, so the wifi icon will blink. After few seconds, your smartphone device would have shared the Wifi…

Five More Indian Languages - Google Translate

Google Translate add 5 more indian language translation like Bengali, Gujarati, Kannada, Tamil and Telugu.Till Today Google Translation supports 63 languages. As a indian bloggger its a happy to announce that all indic languages sites and blogs become internationalized one. All indic bloggers and sites owners have to attach the google translate widgets to their sites so that the internationalized reader can realize the value of your blog and may be a chance of becoming the readers.



How to Add The Google Translate Widgets on Blog or Sites

Just Add the Below code to internationalized your blog or site

<div id="google_translate_element"></div><script>
function googleTranslateElementInit() {
new google.translate.TranslateElement({
pageLanguage: 'en'
}, 'google_translate_element');
}
</script><script src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>

If you want to customize the Goog…

Samsung Android 6.0 Marshmallow Supported Devices

Android Marshmallow is finally available. List of Samsung Device that can be upgraded to Android 6.0 Marshmallow.


Samsung Galaxy S6 edge+ Samsung Galaxy Note5Samsung Galaxy A8Samsung Galaxy A7Samsung Galaxy S6 edgeSamsung Galaxy S6Samsung Galaxy Note 4Samsung Galaxy AlphaSamsung Galaxy S5