How to build such a simple mysql multipart query????

Question

MySQL

Hi all. Please help me make a request. It is necessary that the limit value be the result of the query. I can’t do it either. (

select * from goods limit (select count(*) form goods where catid='1405')

Answer 1

Leave only internal chaos and you will have a limit, your request has no logic