i want to do this
$this->connection->query("SELECT * FROM database WHERE all_columns LIKE '%word%' ");
how can i do this ?
Asked
Active
Viewed 31 times
0
Aldwoni
- 1,168
- 10
- 24
Mfdsix Indo
- 23
- 8
-
what u have tried? – Moby M Sep 12 '17 at 07:19
-
Nope, one LIKE per column is needed, for each table... – jarlh Sep 12 '17 at 07:19
-
1well, aren't you already doing this? – Shinra tensei Sep 12 '17 at 07:19
-
Don't you know where you store your data? – jarlh Sep 12 '17 at 07:20
-
i have tried to search about this. but i think it's possible to do this without defined where colum1 like %word% or column2 like %word% or column3 like %word% – Mfdsix Indo Sep 12 '17 at 07:23
-
`but i think it's possible to do this without defined where colum1 like %word% ....`. No it's not possible – Alive to die - Anant Sep 12 '17 at 07:37