SELECT c1, c2, c3, FROM tb WHERE id < 1000 AND content="mytest* as test"