shortest way

[asmith]

if want to search a table like :

select * from table where (aa1 = "john" and aa2="smith") or (aa1="smith" and aa2="john") or (aa3 ....

 

can  i type it in a shorter way ? 

i want to search if 2 values are in a row or not , no matter under which column  , but in the same row .

thanks

[beebum]

Have a look at fulltext index.

If you index the columns, you can then do something like

  match (indexed_columns) against (+john +smith)