Buy Now
Sign in

CC v5

kate_ee , November 07 2018
K
kate_ee 33
November 07 2018 #381338
how would I change the searchable fields from "=" to "like %..%" ?
below is extracted from debug output, thank you in advance.
 ...  WHERE `sclt`.`Category` = 'Concert Band' AND `sclt`.`ScoreName` = 'Bravo' ORDER BY `sclt`.`ScoreName`, `sclt`.`AuthorName` LIMIT 50
...  WHERE `sclt`.`Category` = 'Concert Band' AND `sclt`.`ScoreName` LIKE  '%Bravo%' ORDER BY `sclt`.`ScoreName`, `sclt`.`AuthorName` LIMIT 50