CODE EXAMPLE FOR SQL

how to select one row in mysql

SELECT * FROM tbl WHERE id = 123 OR colname4 = 'x' OR colname8 = 'y' LIMIT 1