This basically is a pivot table. A nice tutorial on how to achieve this can be found here: http://www.artfulsoftware.com/infotree/qrytip.php?id=78 I advise reading this post and adapt this solution to your needs. Update After the link above is currently not available any longer I feel obliged to provide some additional information for all of you searching … Read more
The Problem In MySQL, certain words like SELECT, INSERT, DELETE etc. are reserved words. Since they have a special meaning, MySQL treats it as a syntax error whenever you use them as a table name, column name, or other kind of identifier – unless you surround the identifier with backticks. As noted in the official … Read more
At first glance… All you need is a GROUP BY clause with the MAX aggregate function: SELECT id, MAX(rev) FROM YourTable GROUP BY id It’s never that simple, is it? I just noticed you need the content column as well. This is a very common question in SQL: find the whole data for the row … Read more
Fix your data model! Don’t store multiple values in a single column. Learn proper SQL syntax! Never use commas in the FROM clause. Always use proper, explicit, standard JOIN syntax. With that said, you don’t need to split the string. You can use string operations: AND CONCAT(‘-‘, eo.photosId, ‘-‘) LIKE CONCAT(‘%-‘, er.pNumber, ‘-%’) But you … Read more
This should do the trick: SELECT title, description, ROUND ( ( LENGTH(description) – LENGTH( REPLACE ( description, “value”, “”) ) ) / LENGTH(“value”) ) AS count FROM <table>
Backticks are to be used for table and column identifiers, but are only necessary when the identifier is a MySQL reserved keyword, or when the identifier contains whitespace characters or characters beyond a limited set (see below) It is often recommended to avoid using reserved keywords as column or table identifiers when possible, avoiding the … Read more