Table search (there are 51 of them), how to do it?

Question

PHP

Good afternoon. I have an items table. In it, according to the user's id, we find the id of the column that belongs to the user. Question: you need to find out in which column item0...item51 (the data is written randomly in them) the item is located (the entry there is: 50|100 50 is the id, 100 is the number) and display the quantity, that is, which is in the column. And one more question: You need to find all (in those columns) data 54|name and write the number of found or the word "is".

Answer 1

In it, according to the user's id, we find the id of the column that belongs to the user

Your database is very, very wrong.