MySQL full text search equivalents to Google search: Difference between revisions

MySQL full text search equivalents to Google search (edit)

1,099 bytes added , 19 December 2024

15,032

edits

@@ Line 184: / Line 184: @@
    </tr>
 </table>
+Create a Google Sheets formula that suggests a title by extracting text leading up to the "AI agent" mention. {{exclaim}} case-insensitive!:
+<pre>
+=IF(
+  REGEXMATCH(A2, "(?i)\bAI\s*agents?\b"),
+  REGEXEXTRACT(
+    A2,
+    ".{0,10}(?i)\bAI\s*agents?\b.{0,10}"
+  )&" ...",
+  ""
+)
+</pre>
+Here's a breakdown of the Google Sheets formula that extracts excerpts containing "AI agent" or "AI agents":
+The formula has two main parts:
+# REGEXMATCH to check if the phrase exists
+# REGEXEXTRACT to get the surrounding context if found
+Pattern explanation:
+* `(?i)` makes the match case-insensitive
+* `\b` ensures word boundaries
+* `\s*` allows any number of spaces
+* `s?` makes the 's' optional (matches both singular and plural)
+The formula will:
+* Search for "AI agent" or "AI agents" in cell A2
+* If found, extract up to 10 characters before and after the match
+* Add "..." to indicate truncation
+* Return empty string if no match
+Will match:
+* "AI agent"
+* "AI agents"
+* "ai Agent"
+* "Ai AGENTS"
+* "The AI agent is"
+- "Multiple AI agents are"
+Won't match:
+* "AIagent"
+* "AImagent"
+* "AI agentify"
 === Microsoft  Spreadsheet approach ===