SELECT * FROM index1 WHERE REGEX(name, 'D.+');ctrl + cSELECT * FROMsearch data in specified index | index1name of the index to search in |
WHERElist search conditions | REGEXfunction to match regex to the specified attribute |
namename of the attribute to match against regular expression | 'D.+'regular expression pattern to check |
More of Manticoresearch
- JSON over HTTP protocol example
- How to index TSV data
- Searching data in real time (RT) index using SQL
- Server config example
- Search query example using Mysql protocol
- How to run indexing for specific plain index
- How to index data from PostgreSQL
- Connect to Manticoresearch using Mysql client
- How to reindex all plain indexes
See more codes...