How to get two words from one column in MYSQL


Problem :

I have a column called process in my table called orders. I am trying to display process that have waiting and processing.

I have tried SELECT process FROM orders WHERE process='waiting' AND process='processing'

and

SELECT process FROM orders WHERE process='waiting', process='processing'

However, it's not working. How can I do this?

Example:

orderid process 
   1    waiting
   2    
   3    

Then the process changes of the orderid 1 to processing from waiting

The results would still display that order but with processing.

Right now, when the order changes from waiting it dissappears. I'd like to be able to see it processing also



Solution :

A field can not have two different values in a row. You should use OR instead of AND or use following query:

SELECT process FROM orders WHERE process IN ('waiting', 'process');

Mysql Tutorials

Mysql Howto..

How to query entries that exist in one table and not the other using PHP/mySQL?

How to display Posts From Friends php and MySql [closed]

How to select rows from last 2 hours in Doctrine

How to move a system to cloud?

how to exclude white spaces in mysql

Not sure how to do ajax functions inside of javascript to get to mysql

How to take script in MySQL Workbench 6.0?

How to refresh datagridview binding in vb.net or C#?

How to implement a mapped keyword match with multiple keywords and preference based on number of hits?

How to store the apostrophe into MySQL database from user input? [duplicate]

How to convert string with date and time AM/PM to 24 Hour mysql timestamp format

How to configure log4net for mySQL?

How to use php sprintf to append positve values with “+” but ignore null values

How to put images on database MYSQL [closed]

How to avoid a duplicate row situation in mysql query below?

How to populate JList with data from another JList

How to optimize mysql query getting categories and subcategories

How to perform an SQL query x minutes after another one is executed?

mysql table contains 6 coluns but csv file contains 4 columns so how to import csv file using load data infile in mysql [closed]

How to perform targeted select queries on main DB instance when using Amazon MySQL RDS and Read replica?

How to working with mx.rpc.Responder in AS3

How to set Hibernate Configuration properties to connect to Mysql using Fabric driver

phpinfo() shows MySQL, PMA shows MariaDB

how to join 2 mysql tables

How to design a set of database tables with dynamic attributes?

How to fix Incorrect string value when trying to convert from Latin1 to UTF8 error in mysql?

How to change password and/or connect to mysql database MAMP?

How to parse a mysql slow query log into something useful?

In PHP, how to achieve the same purpose like StringTokenizer in Java?

Showing multiple table rows in PHP