Is there a way to create a full-text index in Base like there is in MySQL or SQL Server? Ultimate goal is to make a user-friendly search/query feature that will search a single column for a keyword and display results.
I am using LibreOffice 4.0.2.2.
Not an index, but I have used constructs like this to do case-insensitive full-text search of a field for embedded (HSQLDB) databases.
SELECT * FROM CONTACTS WHERE UPPER(LASTNAME) LIKE '%' || UPPER(:x) || '%';
The user is prompted to enter the value of x and the records that contain that value in the field are returned.