Posts Tagged ‘query’How to order the results of MySQL query?Usually most of the work done with MySQL involves pulling down data from a MySQL database. In MySQL, data is retrieved with the “SELECT” keyword. Think of SELECT as working the same way as it does on your computer. If you wanted to copy some information in a document, you would first select the desired information, then copy and paste. How to include a conditional in my MySQL query?You will usually need to apply some logic to the query that you apply to a table, and this is easily done with the WHERE keyword. How to group the results of a MySQL query?If you want to group the results by a particular field value rather than listing all results individually, then you use the GROUP BY keyword. How to find the number of rows affected by a query?With mysql it is usually just a case of learning which function to use, and this is no exception. |
|