mysql - Select and wait until where clause is true -

mysql - Select and wait until where clause is true -

i want create mysql select "select * table state=1" , shouldt wait until status results true. polling not acceptable. tried udf function , sockets more complex , want inquire if there solution thats running

cheers

mysql user-defined-functions