How to get two words from one column in MYSQL
I have a column called
process in my table called
orders. I am trying to display
process that have
I have tried
SELECT process FROM orders WHERE process='waiting' AND process='processing'
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
The results would still display that order but with
Right now, when the order changes from
waiting it dissappears. I'd like to be able to see it
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');
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]