The Ultimate Guide to High Availability with MariaDB

Comments - Search is not working

 
3 years, 5 months ago Ian Gilfillan
Re: Search is not working [Answer]

You are not only searching for üfug0ew u9+ie0r but also various categories. You probably need to use parenthesis to sort out your precedence, for example:

SELECT ... WHERE (... OR ... OR ...) AND (... OR ... OR ...)
 
3 years, 5 months ago Leo Schneider
Re: Search is not working

Okay, thank you. Now it works! My code:

SELECT * FROM `suche` WHERE (`titel` LIKE '%dgiu ebugh eruß9g u9ßsh re%' OR `snippet` LIKE '%dgiu ebugh eruß9g u9ßsh re%' OR `text` LIKE '%dgiu ebugh eruß9g u9ßsh re%') AND (`kategorie` LIKE 'Informationen' ) ORDER BY `suche`.`bearbeitungs_datum` ASC, `suche`.`erstellungs_datum` ASC

 
3 years, 5 months ago Daniel Black
Re: Search is not working

For large kategorie lists you can use IN rather than LIKE since there's no pattern match: AND kategorie IN ('Geschichte', 'Informationen', 'Neuigkeiten', 'Fakten rund um den Ort', 'Dir ist langweilig?')

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.