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
- List all indexes on the server
- Server config example
- How to index data from PostgreSQL
- JSON over HTTP protocol example
- How to index XML data
- How to index data from Mysql
- Find Manticore search version
- Searching data in real time (RT) index using SQL
- Search query example using Mysql protocol
See more codes...