A Gentle Introduction to

SQL

SELECT

Construct queries


Full text search with SQL? such as i want to find a specific word in any colum of the table
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.
mysql variations:
The LIKE operator is case insensitive.

access
db2
mysql
oracle
postgres
sqlserver