Skip to content
Home » Archives for Chris Leather » Page 2

Chris Leather

Find Duplicate Rows Query

Here’s an SQL query that’ll return all the duplicate rows in your table. SELECT `id`, COUNT(*) as `dup` FROM `table_name` GROUP BY `id` HAVING `dup` > 1 ORDER BY `dup`

Brief History of SEO

This article is just a quick look at how search engine optimisation has changed over the years and how the SEO “expert” and the search engines have played a game of “cat and mouse” over the years. It is only a brief look at some of the ways better search engine ranks could be achieved by SEO and how the search engine algorithms were updated in response.Read More »Brief History of SEO