Hi Florian, *, On Wed, Mar 14, 2012 at 5:00 PM, Florian Effenberger <[email protected]> wrote: > Texts to search for are: > > - "Pforzheim" (the location of the bank), > - "Freies Office Deutschland e.V." (the association collecting money on our > behalf, which will soon change since TDF an own entity now), > - "[email protected]" (the former PayPal address which I am > changing to paypal@ right now to make the account transfer easier) > - "tax" (since we at some pages link to toe FrODeV tax-deduction > confirmation) > > Can someone help me with searching the SQL database? We need to adjust the > PayPal account and soon the account owner.
mysql> SELECT Subsite.Title, URLSegment, SiteTree_Live.ID ID FROM SiteTree_Live JOIN Subsite ON Subsite.ID = SubsiteID WHERE Content LIKE "%Pforzheim%" OR Content LIKE "%Freies Office%" OR Content LIKE "% tax %" OR Content LIKE "%[email protected]%" ORDER BY Title; +----------------------+----------------------+------+ | Title | URLSegment | ID | +----------------------+----------------------+------+ | Esperanto NL Project | donaci | 966 | | Finnish NL Project | 2011-06-15 | 1365 | | Finnish NL Project | 2012-02-20 | 1889 | | German NL Project | mitarbeiten | 91 | | German NL Project | faq-zu-libreoffice | 106 | | German NL Project | verwaltungen | 218 | | Italian NL Project | donazioni | 1141 | | Main | donate | 241 | | Spanish NL Project | donacion | 661 | | Z Challenge | why | 926 | | Z Challenge | donate | 928 | | Z Challenge | spenden | 934 | | Z Challenge | warum | 935 | | Z Challenge | done | 956 | | Z Challenge | donate-fr-FR | 1020 | | Z Challenge | donate-ru-RU | 1024 | | Z Challenge | doacao | 1034 | | Z Challenge | donate-el-GR | 1068 | | Z TDF | foundation | 1119 | | Z TDF | supporters | 1122 | | Z TDF | contribution | 1121 | | Z TDF | board | 1679 | | Z TDF | membership-committee | 1678 | | Z TDF | history | 1680 | +----------------------+----------------------+------+ 24 rows in set (0.12 sec) HTH - use https://www.libreoffice.org/admin/show/<id> to view it in the backend without having to navigate around manually. ciao Christian -- Unsubscribe instructions: E-mail to [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/website/ All messages sent to this list will be publicly archived and cannot be deleted
