15,047
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→find unique (non duplicated) data
| Line 79: | Line 79: | ||
== find unique (non duplicated) data == | == find unique (non duplicated) data == | ||
* SELECT DISTINCT column FROM table<ref>[http://dev.mysql.com/doc/refman/5.0/en/distinct-optimization.html MySQL :: MySQL 5.0 Reference Manual :: 8.3.1.13 DISTINCT Optimization]</ref> | * SELECT DISTINCT column FROM table<ref>[http://dev.mysql.com/doc/refman/5.0/en/distinct-optimization.html MySQL :: MySQL 5.0 Reference Manual :: 8.3.1.13 DISTINCT Optimization]</ref> | ||
* (1)SELECT * FROM table; (2)Using [http://php.net/manual/en/function.array-unique.php PHP: array_unique] for data handling two or more columns | |||
* SELECT column FROM table GROUP BY column | * SELECT column FROM table GROUP BY column | ||
== text match == | == text match == | ||