Maverick — Thu, 27 Jul 2000 18:45:42 +0000

It works the same way with numbers as it does with letters, so:

SELECT * FROM db WHERE field LIKE "AR17";

will return any field where the value is AR17

SELECT * FROM db WHERE field LIKE "%AR17%";

will return any field where AR17 is anywhere in the field

or simply for numbers:

SELECT * FROM db WHERE field LIKE "17";

SELECT * FROM db WHERE field LIKE "%17%";

returns where 17 is anyplace in the field