Ask Your Question

Base: Full-Text Search [closed]

asked 2013-06-11 21:30:53 +0100

MadChickenz gravatar image

updated 2015-11-02 05:12:18 +0100

Alex Kemp gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 05:12:26.908818

1 Answer

Sort by » oldest newest most voted

answered 2013-06-12 16:43:48 +0100

w_whalley gravatar image

updated 2013-06-12 17:32:26 +0100

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.

edit flag offensive delete link more

Question Tools


Asked: 2013-06-11 21:30:53 +0100

Seen: 244 times

Last updated: Jun 12 '13