search with %

admin

Administrator
Staff member
I want to search a field which contains "test", but not "testing" or "tester"... how do I have to correct this string? With %... or something?

SELECT * FROM db_leggi WHERE 1=1 AND titolo_l LIKE 'test' OR numero_l LIKE 'test'
 
Back
Top