Filter Records from Mysql

General
1

MQTT Data is [{"device_mac":"BC572900A0CD","temp":24.56,"humidty":50.81,"rssi":-83,"ver":1,"x0":-968,"y0":-359,"z0":-93,"type":1,"time":1673811297266000000},{"host":"BC572900A0CD"}]
[{"device_mac":"BC572900A052","temp":24.45,"humidty":60.62,"rssi":-85,"ver":1,"x0":-46,"y0":46,"z0":1031,"type":1,"time":1673811393808000000},{"host":"BC572900A052"}]

Consider I have a Mysql table which has device mac address.
eg. select mac_address from device_info ;
BC572900A052
And I want to use a query and get records and restrict or limit data other than the result set

And Only items that are available in the result set should be filtered from the mqtt data ,

How to filter records using mysql from mqtt topic

2

In order to make code readable and usable it is necessary to surround your code with three backticks (also known as a left quote or backquote ```)

``` 
   code goes here 
```

You can edit and correct your post by clicking the pencil :pencil2: icon.

See this post for more details - How to share code or flow json

3

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.