how to make one variable = another variable in mysql

[jarow]

Very new to mysql and php.

How do I write a statement in MySql that says the value of one database field equals the value of another. For example, if a value is entered for $genus that same value should appear in $syn_genus.

Thanks

[[deleted]]

What exaclty do you mean, because the variables you mentiond are PHP vars, and I can't imagine you don't know how to do

$var = $othervar;