How to write an SQL query, searching for the maximum match with a value?

Question

PHP

There are two tables :
wp_konkurs_bets

wp_konkurs

Need among all wp_konkurs records to find the id whose user_bet field matches the bet_val field value in the wp_konkurs table as much as possible and the user_time time is the earliest , how to write such a query ?

Answer 1

ORDER BY ABS(`wp_konkurs`.`user_bet` - `wp_konkurs_bets`.`bet_val`), `user_time`
LIMIT 1

Only it is not clear on what fields the tables are connected.