0
Eae,
I have two fields in a mysql table, Description and degree.
how do I do when I search type WORD and 4 ( being WORD from the Description field and 4 from the Grade field? a result appears?
PS.: Both description and degree are in text mode.
PS2.: if I search separately it finds result (like, if I type only WORD it finds, and if I search only 4 it finds also)
0
From what I understand you want to do a query that looks in two fields at once if something is in one field or the other...if that’s it and only use OR.
If you want to search for two words typed in the same input, you have to treat them first. I don’t know much about php, but there must be some function that separates a string, like a split() where you pass as argument a separator, this separator can be a space, a comma or a tab.
Yes, you got it right, I’ve tried with the OR, but the same result. If I type only WORD it finds in the description field, if I type only 4 it finds in the grade field, but if I type WORD 4 it does not find in either of the two fields.
@Eduardorodrigues Rodrigo is right, you must use a explode in vdd, split is for java kkkkkk, you can use a foreach to query, I’ll send an example in a reply, it is more organized
0
Making the explode and assembling your query:
//Separo a frase por espaço
$v = explode(" ", "palavra 4");
$query = 'SELECT * FROM sua_tabela WHERE ';
foreach ($v as $key => $value) {
$query .= "campo_1 LIKE '%" . $value . "%' OR campo_2 LIKE '%" . $value . "%' OR ";
}
//Retiro o último 'OR '
echo substr($query, 0, -3);
The example prints: SELECT * FROM sua_tabela WHERE campo_1 LIKE '%palavra%' OR campo_2 LIKE '%palavra%' OR campo_1 LIKE '%4%' OR campo_2 LIKE '%4%'
This example is very generic, but with it you can understand how you can build your query very simply
Thanks man, I understood and it worked here
@Eduardorodrigues ;)
Browser other questions tagged php mysql quest
You are not signed in. Login or sign up in order to post.
First post the query you’re using, so we can help you.
– Mauro Alexandre
@Mauroalexandre put it there ^^
– Eduardo Rodrigues
A
ANDsolve it, right? Liketal campo LIKE '%sua palavra%' AND tal campo LIKE '%outra palavra%', I guess that’s it, I didn’t quite understand your question– Woton Sampaio
@Wotonsampaio is like this, many times what will type in this system is present in more than one field, but the query does not show the result when I type something that is present in the two fields, using the example I put in the question if I type word 4, shows no result, even having word in the Description field and 4 in the grade field
– Eduardo Rodrigues