MySQL Select from (no column)

[maxudaskin]

Is it possible to select from a table using WHERE without putting in a column name?

Kind of like this:

 

mysql_query("select * from flights WHERE  LIKE '{$searchfield}'");

[Barand]

No

[GingerRobot]

What did you hope you would achieve by searching in this way? If you tell us what you are actually trying to do, we might be able to tell you a way of doing it.

[maxudaskin]

I was hoping to have it so that when somone searches, it will select that from any column instead of just one.

[The Little Guy]

Maybe this is what your looking for:

 

mysql_query("select * from flights WHERE 
colum1 LIKE '{$searchfield}'
AND colum2 LIKE '{$searchfield}'
AND colum3 LIKE '{$searchfield}'
AND colum4 LIKE '{$searchfield}'");

[maxudaskin]

Maybe this is what your looking for:

 

mysql_query("select * from flights WHERE 
colum1 LIKE '{$searchfield}'
AND colum2 LIKE '{$searchfield}'
AND colum3 LIKE '{$searchfield}'
AND colum4 LIKE '{$searchfield}'");

 

So...

mysql_query("select * from flights WHERE 
colum1 LIKE '{$searchfield}', colum2 LIKE '{$searchfield}', colum3 LIKE '{$searchfield}', colum4 LIKE '{$searchfield}'")

?

 

[The Little Guy]

oh... yeah... I forgot the commas, but yea something like that.

[Barand]

You'd want OR and not AND if you want ro search for the value in any column. If you use AND, it has to be in EVERY column

 

$result = mysql_query("select * from flights WHERE 
          (column1 LIKE '%$searchfield%')
           OR (column2 LIKE '%$searchfield%')
           OR (column3 LIKE '%$searchfield%')
           OR (column4 LIKE '%$searchfield%') ");