Finding an Item Number?

[John Adams]

To find items containing any of your letters:
select * from items where name like '%partial name%';

To find items starting with any of your letters:
select * from items where name like 'partial name%';

To find items ending any of your letters:
select * from items where name like '%partial name';

etc... "like" is the option you're looking for. the percents '%' are like wildcards.


Example:
select * from items where name like '%ration%';

...would return anything in the Item Database with the word "ration" anywhere in the name.


If you do not want to see the whole Item record, change "select *" to "select id, name"... etc. A valid column name from the Items table.