search with %

[nicdp]

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'

[ace21]

try this

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

the spaces before and after assure that the exact word test will be the only result accepted.

Ace21

[nicdp]

It doesn't work... result=everything this way...