<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>SQLWordForms</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="mnoGoSearch 3.3.9 reference manual"
HREF="index.html"><LINK
REL="UP"
TITLE="mnoGoSearch command reference"
HREF="msearch-cmdref.html"><LINK
REL="PREVIOUS"
TITLE="Spell"
HREF="msearch-cmdref-spell.html"><LINK
REL="NEXT"
TITLE="StartHops"
HREF="msearch-cmdref-starthops.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="mnogo.css"><META
NAME="Description"
CONTENT="mnoGoSearch - Full Featured Web site Open Source Search Engine Software over the Internet and Intranet Web Sites Based on SQL Database. It is a Free search software covered by GNU license."><META
NAME="Keywords"
CONTENT="shareware, freeware, download, internet, unix, utilities, search engine, text retrieval, knowledge retrieval, text search, information retrieval, database search, mining, intranet, webserver, index, spider, filesearch, meta, free, open source, full-text, udmsearch, website, find, opensource, search, searching, software, udmsearch, engine, indexing, system, web, ftp, http, cgi, php, SQL, MySQL, database, php3, FreeBSD, Linux, Unix, mnoGoSearch, MacOS X, Mac OS X, Windows, 2000, NT, 95, 98, GNU, GPL, url, grabbing"></HEAD
><BODY
CLASS="refentry"
BGCOLOR="#EEEEEE"
TEXT="#000000"
LINK="#000080"
VLINK="#800080"
ALINK="#FF0000"
><!--#include virtual="body-before.html"--><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
><SPAN
CLASS="application"
>mnoGoSearch</SPAN
> 3.3.9 reference manual: Full-featured search engine software</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="msearch-cmdref-spell.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="msearch-cmdref-starthops.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="cmdref-sqlwordforms"
></A
>SQLWordForms</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN12590"
></A
><H2
>Name</H2
><B
CLASS="command"
>SQLWordForms</B
> -- loads synonyms or word forms from the database<P
><B
></B
><TT
CLASS="filename"
>search.htm</TT
></P
></DIV
><DIV
CLASS="refsynopsisdiv"
><A
NAME="AEN12596"
></A
><H2
>Synopsis</H2
><P
><B
CLASS="command"
>SQLWordForms</B
> {str}</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN12600"
></A
><H2
>Desription</H2
><P
> <B
CLASS="command"
>SQLWordForms</B
> provides a fuzzy search method,
alternative to <A
HREF="msearch-fuzzy.html#synonyms"
>Synonyms</A
> and
<A
HREF="msearch-fuzzy.html#ispell"
>Ispell</A
>.
</P
><P
> <B
CLASS="command"
>SQLWordForms</B
> allows to specify an <ACRONYM
CLASS="acronym"
>SQL</ACRONYM
>
query which will be executed to generate word forms or synonyms
from the database. The query must return exactly one column with
individual word forms or synonyms in separate rows.
</P
><P
> The query is sent to the database specified in
the <B
CLASS="command"
><A
HREF="msearch-cmdref-dbaddr.html"
>DBAddr</A
></B
> command.
If the case of multiple <B
CLASS="command"
><A
HREF="msearch-cmdref-dbaddr.html"
>DBAddr</A
></B
> commands,
only the first <B
CLASS="command"
><A
HREF="msearch-cmdref-dbaddr.html"
>DBAddr</A
></B
>
is used for word forms generating.
</P
><P
> The <ACRONYM
CLASS="acronym"
>SQL</ACRONYM
> query is executed for every word typed by the user,
with the <CODE
CLASS="varname"
>$1</CODE
> variable replaced to the word.
<DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>Note: </B
>
When using <A
HREF="msearch-cluster.html"
>cluster</A
>,
the <B
CLASS="command"
>SQLWordForms</B
> command
must be specified in the cluster node <ACRONYM
CLASS="acronym"
>XML</ACRONYM
> templates - not in the
front-end <ACRONYM
CLASS="acronym"
>HTML</ACRONYM
> template.
</P
></BLOCKQUOTE
></DIV
>
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN12625"
></A
><H2
>Examples</H2
><DIV
CLASS="informalexample"
><P
></P
><A
NAME="AEN12627"
></A
><PRE
CLASS="programlisting"
> SQLWordForms "SELECT sp1.form FROM spell sp1, spell sp2 WHERE sp1.word=sp2.word AND sp2.form='$1'"
</PRE
><P
></P
></DIV
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN12629"
></A
><H2
>See also</H2
><P
> <A
HREF="msearch-cmdref-affix.html"
>Affix</A
>,
<A
HREF="msearch-cmdref-alwaysfoundword.html"
>AlwaysFoundWord</A
>,
<A
HREF="msearch-cmdref-dehyphenate.html"
>Dehyphenate</A
>,
<A
HREF="msearch-cmdref-ispelluseprefixes.html"
>IspellUsePrefixes</A
>,
<A
HREF="msearch-cmdref-spell.html"
>Spell</A
>,
<A
HREF="msearch-cmdref-stopwordfile.html"
>StopwordFile</A
>,
<A
HREF="msearch-cmdref-synonym.html"
>Synonym</A
>,
<A
HREF="msearch-cmdref-usenumericoperators.html"
>UseNumericOperators</A
>,
<A
HREF="msearch-fuzzy.html#dumpspell"
>the Section called <I
>Dumping Ispell data
<A
NAME="AEN6366"
></A
></I
> in Chapter 10</A
>.
</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="msearch-cmdref-spell.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="msearch-cmdref-starthops.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Spell</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="msearch-cmdref.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>StartHops</TD
></TR
></TABLE
></DIV
><!--#include virtual="body-after.html"--></BODY
></HTML
>
