5th February, 2016 Merging topics

SQL to find the topics with and without . select a.topic_id, a.title, b.topic_id, b.title from topic a, topic b where (a.title like '%.') and b.title = substring(a.title, 1, char_length(a.title)-1) limit 100000; SQL to find the topics with and without s select a.topic_id, a.title, b.topic_id, b.title from topic a, topic b where (a.title like '%s') and b.title = substring(a.title, 1, char_length(a.title)-1) limit 100000; SQL to find the topics with and without The select a.topic_id, a.title, b.topic_id, b.title from topic a, topic b where (a.title like 'The %') and b.title = substring(a.title, 4, char_length(a.title)-3) limit 100000; Notey Iphone App knowledge transfer