Hey I am not good at MySQL but I kind of get a little bit of it, I understand this I think in order of parents,
DB > Table > Row > Data
And the goal is to search through Data, Ill try to explain this so it makes sense, it shouldnt be very tricky i dont think, im just inexperienced
Hey I have a database like this (very small):
For mySQL query:
tables: category, files, reference, type
(These below is where the "info" is stored, I don't know if these are tables/sub-tables or what)
$query = "SELECT * from category like \"%$trimmed%\" ;
I'm guessing the above is looking for only the names of those rows?
So would I do something like:
Is this searching rows? I don't think it is.
$query = "SELECT * from categoryID like \"%$trimmed%\";
Do I have to define which Table then Row to search?
Its not getting any results, I think Im doing that wrong
Does anyone know what Im doing wrong?