how to delete one record in mysql table

[alecoder]

hey all
i want delete one record in mysql table
for example Delete one field where id = “5”
see picture

for example
we have table

id name name2 name3 name4

1 john pavel george abbye

2 alex lilian nick jefry

and i want delete value where id = 1 and if name || name2 || name3|| name4 value john delete then

[Zyppora]

DELETE FROM [tablename] WHERE id = 1 OR name = ‘John’ OR name2 = ‘John’ OR …

That perhaps?