Find "in ubuntu" pattern on askubuntu

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.askubuntu.com/questions/5866/should-ubuntu-and-linux-be-kept-on-question-titles

Ask Ubuntu

Q&A for Ubuntu users and developers

select Id, Title, Tags
from Posts
where (lower(Title) like '% [io]n ubuntu%'
    or lower(Title) like '% with ubuntu%'
    or lower(Title) like '% from ubuntu%'
    or lower(Title) like '% to ubuntu%'
    or lower(Title) like '% [io]n my ubuntu%'
    or lower(Title) like '% with my ubuntu%'
    or lower(Title) like '% from my ubuntu%'
    or lower(Title) like '% to my ubuntu%'
    or lower(Title) like '% [io]n linux%'
    or lower(Title) like '% with linux%'
    or lower(Title) like '% from linux%'
    or lower(Title) like '% to linux%'
    or lower(Title) like '% [io]n my linux%'
    or lower(Title) like '% with my linux%'
    or lower(Title) like '% from my linux%'
    or lower(Title) like '% to my linux%'
    or lower(Title) like '% [io]n gnu/linux%'
    or lower(Title) like '% with gnu/linux%'
    or lower(Title) like '% from gnu/linux%'
    or lower(Title) like '% to gnu/linux%'
    or lower(Title) like '% [io]n my gnu/linux%'
    or lower(Title) like '% with my gnu/linux%'
    or lower(Title) like '% from my gnu/linux%'
    or lower(Title) like '% to my gnu/linux%')
 and not
      (lower(Title) like '%ubuntu 9._%'
    or lower(Title) like '%ubuntu 1[0123]._%')         
order by LastActivityDate

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results