php - select query issue in mysql -

php - select query issue in mysql -

i have mysql table below

id name 1 aaa 2 bbb 3 ccc

now have variable containing random value of column name.

$name = "bbb"; //now value can changed means can ccc or aaa

i want output

id name 2 bbb 1 aaa 3 ccc

if value ccc output should below. row containing value should @ top , rest of rows.

id name 3 ccc 1 aaa 2 bbb

and usual stuck select query. normal select query doesn't work selects 1 item.

$sql = "select * table name='".$name."'";

you can combine order by case.

something like:

select * your_table order case when name=? 0 else 1 end

note have replaced injecting php variable straight prepared statement (the question mark, pdo or mysqli).

in mysql like:

case when name="' . mysql_real_escape_string($name) . '" 0

php mysql sql select