KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am querying a database in Postgres using psql. I have used the following query to search a field called tags that has an array of text as it's data type: select count(*) from planet_osm_ways where 'highway' = ANY(tags); I now need to create a query that searches the tags fields for any word starting with the letter 'A'. I tried the following: select count(*) from planet_osm_ways where 'A%' LIKE ANY(tags); This gives me a syntax error. Any suggestions on how to use LIKE with an array of text?
Tags (comma-separated)
Save Edits
Cancel