I'm trying to create a search based on where items go together in the same table.
So if I input a value like
WHERE (BoxNo LIKE '%') = GoesWith
Maybe you mean,
SELECT * FROM tableName WHERE 'a123' IN (BoxNo, GoesWith)
or maybe this,
SELECT * FROM tableName WHERE BoxNo LIKE '%a123%' AND BoxNo = GoesWith