MySQL full text search equivalents to Google search - Revision history

Planetoid: /* Google sheet approach */

2024-12-20T06:28:03Z

Google sheet approach

@@ Line 186: / Line 186: @@
 Create a Google Sheets formula that suggests a title by extracting text leading up to the "AI agent" mention. {{exclaim}} case-insensitive!:
 <pre>
 =IF(
@@ Line 223: / Line 223: @@
 * "Ai AGENTS"
 * "The AI agent is"
-- "Multiple AI agents are"
+* "Multiple AI agents are"
 Won't match:
@@ Line 229: / Line 229: @@
 * "AImagent"
 * "AI agentify"
 === Microsoft  Spreadsheet approach ===

2024-12-19T10:24:04Z

References or related articles

← Older revision		Revision as of 18:24, 19 December 2024
Line 267:		Line 267:
	* [http://www.w3resource.com/mysql/string-functions/mysql-position-function.php MySQL POSITION() function - w3resource] / [http://www.w3resource.com/mysql/string-functions/mysql-length-function.php MySQL LENGTH() function - w3resource] where the keywords located.		* [http://www.w3resource.com/mysql/string-functions/mysql-position-function.php MySQL POSITION() function - w3resource] / [http://www.w3resource.com/mysql/string-functions/mysql-length-function.php MySQL LENGTH() function - w3resource] where the keywords located.

	== ~~References or related~~ articles ==		== Related articles ==
	to explore strange new worlds / related articles:		to explore strange new worlds / related articles:
	* [http://dev.mysql.com/doc/refman/5.1/en/regexp.html MySQL :: MySQL 5.1 Reference Manual :: 12.5.2 Regular Expressions]		* [http://dev.mysql.com/doc/refman/5.1/en/regexp.html MySQL :: MySQL 5.1 Reference Manual :: 12.5.2 Regular Expressions]
Line 287:		Line 287:
	* does not equal ____		* does not equal ____

	~~references~~		== References ==
	<references/>		<references/>

Line 299:		Line 299:
	[[Category:Search]]		[[Category:Search]]
	[[Category:Data Science]]		[[Category:Data Science]]
			[[Category: Revised with LLMs]]

2024-12-19T10:22:45Z

Google sheet approach

@@ Line 184: / Line 184: @@
    </tr>
 </table>
 === Microsoft  Spreadsheet approach ===

2024-01-13T09:09:42Z

2021-12-01T08:53:52Z

Ignore special characters

← Older revision		Revision as of 16:53, 1 December 2021
Line 47:		Line 47:
	* Approach: (1) remove the html tag (2) remove the return symbol ([https://en.wikipedia.org/wiki/Carriage_return Carriage return]).		* Approach: (1) remove the html tag (2) remove the return symbol ([https://en.wikipedia.org/wiki/Carriage_return Carriage return]).

	Ignore ~~space~~, [https://en.wikipedia.org/wiki/Halfwidth_and_fullwidth_forms Halfwidth and fullwidth symbol] (半形字元和全形字元)		Ignore white spaces, [https://en.wikipedia.org/wiki/Halfwidth_and_fullwidth_forms Halfwidth and fullwidth symbol] (半形字元和全形字元)
	* Examples:		* Examples:
	** Searched the keywords e.g. {{kbd \| key = <nowiki>"嗎有"</nowiki>}} on Google and found the search result contains {{kbd \| key = <nowiki>嗎？有</nowiki>}} & {{kbd \| key = <nowiki>嗎- 有</nowiki>}}.		** Searched the keywords e.g. {{kbd \| key = <nowiki>"嗎有"</nowiki>}} on Google and found the search result contains {{kbd \| key = <nowiki>嗎？有</nowiki>}} & {{kbd \| key = <nowiki>嗎- 有</nowiki>}}.

2021-06-16T06:44:05Z

Instruction of SQL syntax

← Older revision		Revision as of 14:44, 16 June 2021
Line 129:		Line 129:
	)		)
	ELSE ''		ELSE ''
	END AS "scrapbook";		END AS `scrapbook`;

	-- > returns 行比武時，以此功對付吸星大法，使其全身凍僵、天池		-- > returns 行比武時，以此功對付吸星大法，使其全身凍僵、天池
Line 152:		Line 152:
	)		)
	ELSE ''		ELSE ''
	END AS "scrapbook"		END AS `scrapbook`

	-- Returned result of scrapbook column: Show 10 characters before or after the search keywords.		-- Returned result of scrapbook column: Show 10 characters before or after the search keywords.

2021-06-16T06:43:13Z

SQL syntax

← Older revision		Revision as of 14:43, 16 June 2021
Line 82:		Line 82:
	)		)
	ELSE ''		ELSE ''
	END AS "scrapbook"		END AS `scrapbook`

	-- Returned result of scrapbook column: Show 10 characters before or after the search keywords.		-- Returned result of scrapbook column: Show 10 characters before or after the search keywords.
Line 89:		Line 89:

	Run on [http://sqlfiddle.com/#!9/096df3/5/0 sqlfiddle]		Run on [http://sqlfiddle.com/#!9/096df3/5/0 sqlfiddle]


	==== Instruction of SQL syntax ====		==== Instruction of SQL syntax ====

2021-06-04T14:18:27Z

Instructions

← Older revision		Revision as of 22:18, 4 June 2021
Line 91:		Line 91:


	==== ~~Instructions~~ ====		==== Instruction of SQL syntax ====
	(1) [https://www.w3resource.com/mysql/string-functions/mysql-position-function.php MySQL POSITION() function - w3resource] "MySQL POSITION() returns the position of a substring within a string."		(1) [https://www.w3resource.com/mysql/string-functions/mysql-position-function.php MySQL POSITION() function - w3resource] "MySQL POSITION() returns the position of a substring within a string."
	<pre>		<pre>

2021-06-04T14:17:50Z

MySQL approach

← Older revision		Revision as of 22:17, 4 June 2021
Line 58:		Line 58:

	=== MySQL approach ===		=== MySQL approach ===
			==== SQL syntax ====
	Input search keywords, and returned the the first occurrence of matched paragraph. Using MySQL [http://www.w3resource.com/mysql/string-functions/mysql-substring-function.php SUBSTRING() function], [http://www.w3resource.com/mysql/string-functions/mysql-position-function.php POSITION() function] & [http://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php CHAR_LENGTH() function].		Input search keywords, and returned the the first occurrence of matched paragraph. Using MySQL [http://www.w3resource.com/mysql/string-functions/mysql-substring-function.php SUBSTRING() function], [http://www.w3resource.com/mysql/string-functions/mysql-position-function.php POSITION() function] & [http://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php CHAR_LENGTH() function].

Line 87:		Line 88:
	</pre>		</pre>

			Run on [http://sqlfiddle.com/#!9/096df3/5/0 sqlfiddle]

	Instructions:
			==== Instructions ====
	(1) [https://www.w3resource.com/mysql/string-functions/mysql-position-function.php MySQL POSITION() function - w3resource] "MySQL POSITION() returns the position of a substring within a string."		(1) [https://www.w3resource.com/mysql/string-functions/mysql-position-function.php MySQL POSITION() function - w3resource] "MySQL POSITION() returns the position of a substring within a string."
	<pre>		<pre>

2021-06-04T14:13:06Z

← Older revision	Revision as of 22:13, 4 June 2021
(No difference)

← Older revision		Revision as of 17:09, 13 January 2024
Line 244:		Line 244:
	references		references
	<references/>		<references/>

	~~== Related news ==~~

	~~{{News feed \| title = MySQL OR nosql related news \| feed = <rss>https://news.google.com/rss/search?q=MySQL+OR+nosql&hl=zh-TW&gl=TW&ceid=TW:zh-Hant</rss>~~
	}}