View source for Full text search

Full text search with SQL? such as i want to find a specific word in any colum of the table
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
The "brute force" method is to use use the LIKE operator against any of the
fields to be searched. This will be relatively expensive - but probably
good enough in many cases. The term to search for should be quoted and
placed within two wild cards.

You should construct the string literal in some scripting language -
don't forget to quote it.
</div>
<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def e-oracle'>SELECT name FROM bbc
WHERE lower(name) LIKE '%the%'</source>
<source lang='sql' class='def e-sqlserver'>SELECT name FROM bbc
WHERE name LIKE '%the%'</source>
<source lang='sql' class='def e-mysql'>SELECT name FROM bbc
WHERE name LIKE '%the%'</source>
<source lang='sql' class='def e-access'>SELECT name FROM bbc
WHERE name LIKE '%the%'
</source>
<source lang='sql' class='def'>SELECT name FROM bbc
WHERE name LIKE '%the%'
</source>
<div class="ecomm e-oracle" style="display: none">The LIKE command is case sensitive - to do a case insensitive search
you should force the searched field and the search term into lower (or upper) case. Without this we would miss "Bahamas, The"</div>
<div class="ecomm e-sqlserver" style="display: none">The LIKE operator is case insensitive.</div>
<div class="ecomm e-mysql" style="display: none">The LIKE operator is case insensitive.</div>
<div class="ecomm e-access" style="display: none">String comparison in Access is always case insensitive.</div>
</div>
{{SELECT Ref}}