Search post where comment text like '...'

0

Please login or register to vote for this query.

(click on this box to dismiss)

Also included Score and text

Music Fans Meta

Q&A for music historians, critics, and fans

SELECT * FROM Comments
WHERE (LOWER(Text) LIKE LOWER('%smart city%') OR LOWER(Text) LIKE LOWER('%smartcity%') OR LOWER(Text) LIKE LOWER('%#smartcity%') OR LOWER(Text) LIKE LOWER('%smart cities%') OR LOWER(Text) LIKE LOWER('%smartcities%') OR LOWER(Text) LIKE LOWER('%#smartcities%') OR LOWER(Text) LIKE LOWER('%smart municipalities%') OR LOWER(Text) LIKE LOWER('%smartmunicipalities%') OR LOWER(Text) LIKE LOWER('%#smartmunicipalities%') OR LOWER(Text) LIKE LOWER('%smart towns%') OR LOWER(Text) LIKE LOWER('%smarttowns%') OR LOWER(Text) LIKE LOWER('%#smarttowns%') OR LOWER(Text) LIKE LOWER('%smart villages%') OR LOWER(Text) LIKE LOWER('%smartvillages%') OR LOWER(Text) LIKE LOWER('%#smartvillages%') OR LOWER(Text) LIKE LOWER('%smart communities%') OR LOWER(Text) LIKE LOWER('%smartcommunities%') OR LOWER(Text) LIKE LOWER('%#smartcommunities%') OR LOWER(Text) LIKE LOWER('%machineQ%') OR LOWER(Text) LIKE LOWER('%machine Q%') OR LOWER(Text) LIKE LOWER('%smart parking%') OR LOWER(Text) LIKE LOWER('%smart meter%') OR LOWER(Text) LIKE LOWER('%smart street lighting%') OR LOWER(Text) LIKE LOWER('%smart street lights%') OR LOWER(Text) LIKE LOWER('%autonomous street lighting%') OR LOWER(Text) LIKE LOWER('%autonomous streetlights%') OR LOWER(Text) LIKE LOWER('%smart streetlights%') OR LOWER(Text) LIKE LOWER('%garbage sensors%') OR LOWER(Text) LIKE LOWER('%trash sensors%') OR LOWER(Text) LIKE LOWER('%solar panel monitors%') OR LOWER(Text) LIKE LOWER('%waste management sensors%') OR LOWER(Text) LIKE LOWER('%smart recycling%') OR LOWER(Text) LIKE LOWER('%bin sensors%') OR LOWER(Text) LIKE LOWER('%moisture sensors%') OR LOWER(Text) LIKE LOWER('%autonomous logistics hubs%') OR LOWER(Text) LIKE LOWER('%autonomous vehicles%') OR LOWER(Text) LIKE LOWER('%sensor-equipped inhalers%') OR LOWER(Text) LIKE LOWER('%turf sensors%') OR LOWER(Text) LIKE LOWER('%barometric pressure sensors%') OR LOWER(Text) LIKE LOWER('%lighting controller%') OR LOWER(Text) LIKE LOWER('%storm drain sensor%') OR LOWER(Text) LIKE LOWER('%trash can sensor%') OR LOWER(Text) LIKE LOWER('%parking sensor%') OR LOWER(Text) LIKE LOWER('%emergency push-button%') OR LOWER(Text) LIKE LOWER('%manhole monitor%') OR LOWER(Text) LIKE LOWER('%manhole detector%') OR LOWER(Text) LIKE LOWER('%parking management%') OR LOWER(Text) LIKE LOWER('%bike tracker%') OR LOWER(Text) LIKE LOWER('%parking spot lock%') OR LOWER(Text) LIKE LOWER('%door monitor%') OR LOWER(Text) LIKE LOWER('%power line theft%') OR LOWER(Text) LIKE LOWER('%flood sensor%') OR LOWER(Text) LIKE LOWER('%air quality sensors%') OR LOWER(Text) LIKE LOWER('%turf sensors%') OR LOWER(Text) LIKE LOWER('%temperature sensors%') OR LOWER(Text) LIKE LOWER('%humidity sensors%') OR LOWER(Text) LIKE LOWER('%air pollution monitoring%') OR LOWER(Text) LIKE LOWER('%vehicle tracking%') OR LOWER(Text) LIKE LOWER('%parking sensors%') OR LOWER(Text) LIKE LOWER('%pet tracking solution%') OR LOWER(Text) LIKE LOWER('%garbage level sensors%') OR LOWER(Text) LIKE LOWER('%Bus seat monitors%') OR LOWER(Text) LIKE LOWER('%power line theft sensors%') OR LOWER(Text) LIKE LOWER('%outdoor air quality sensors%') OR LOWER(Text) LIKE LOWER('%dissolved oxygen sensors%') OR LOWER(Text) LIKE LOWER('%pH sensors%') OR LOWER(Text) LIKE LOWER('%CO2 sensors%') OR LOWER(Text) LIKE LOWER('%CO sensors%') OR LOWER(Text) LIKE LOWER('%scooter tracker%') OR LOWER(Text) LIKE LOWER('%connected parking sensor%') OR LOWER(Text) LIKE LOWER('%connected utility meter%') OR LOWER(Text) LIKE LOWER('%connected rodent traps%') OR LOWER(Text) LIKE LOWER('%connected rat traps%') OR LOWER(Text) LIKE LOWER('%transportation congestion sensors%') OR LOWER(Text) LIKE LOWER('%parking apps%') OR LOWER(Text) LIKE LOWER('%wearable detection%') OR LOWER(Text) LIKE LOWER('%intelligent city%') OR LOWER(Text) LIKE LOWER('%intelligent cities%') OR LOWER(Text) LIKE LOWER('%intelligentcity%') OR LOWER(Text) LIKE LOWER('%intelligentcities%') OR LOWER(Text) LIKE LOWER('%smart parking%') OR LOWER(Text) LIKE LOWER('%smartparking%'))
ORDER BY Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results