White Papers

Return more relevant results using full-text search in MySQL

Category: Data Management

Tags: html, database

Overview This document will show you how to perform full-text searches in MySQL.

In many cases, a full-text search of a database will return better results then a similar search using a LIKE clause in a SELECT query. This is especially true for MySQL systems because that database application has special features specifically designed for full-text searching. This download shows you how to use these special features to perform full-text searches in MySQL.

Have you used full-text searches in My SQL? What kind of results did you get? Was it more efficient or do you prefer SELECT queries?

This download is also available as a TechRepublic article.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
TechRepublic
File Format
PDF
Date Published
May 25, 2006
Format
White Papers
Topics
Database Management

Similiar White Papers

BPM Done Right: 15 Ways To Succeed Where Others Have Failed

BPM Done Right: 15 Ways To Succeed Where Others Have Failed

Business Process Management (BPM) promises are real, but the path to success is littered with pitfalls and shortcuts to

Publisher: Software AG

SQL Server 2000 Enterprise Edition (64-bit): Advantages of a 64-Bit Environment

SQL Server 2000 Enterprise Edition (64-bit): Advantages of a 64-Bit Environment

HP has partnered with Microsoft to provide information about the advantages of a 64-Bit Environment. Microsoft SQL Serv

Publisher: Hewlett-Packard  |  Tags: applications, software

The ROI of Data Governance - A Revenue Generation Perspective

The ROI of Data Governance - A Revenue Generation Perspective

"Concentrating on increasing revenue necessarily means paying attention to metrics such as return on investment (ROI). T

Publisher: DataFlux  |  Tags: data, metadata

Fibre Channel and iSCSI Performance Comparison for DSS Workloads Using SQL Server 2005

Fibre Channel and iSCSI Performance Comparison for DSS Workloads Using SQL Server 2005

For many years, large enterprises have relied on Fibre Channel (FCP) as the default Storage Area Network (SAN) protocol

Publisher: Network Appliance (NetApp)  |  Tags: database, ethernet, ip, tco

Quickly import data into Excel with these techniques

Quickly import data into Excel with these techniques

This sample chapter, taken from Managing Data with Excel, highlights a couple ways to get data from other applica

Publisher: TechRepublic  |  Tags: applications, data, excel

TechRepublic White Papers

Build your own consulting contract using this sample form

Build your own consulting contract using this sample form

Both independent consultants and their clients benefit when they're working with a solid contract. Download this sample

Publisher: TechRepublic  |  Tags: html

Say 'no thanks' the right way with this sample rejection letter

Say 'no thanks' the right way with this sample rejection letter

It's a good practice to let job candidates know when they haven't gotten the job. Use this sample thanks-but-no-thanks l

Publisher: TechRepublic  |  Tags: html

Step by step: Configure a Windows Server 2003 VPN?Server side

Step by step: Configure a Windows Server 2003 VPN?Server side

Set up a Windows Server 2003-based PPTP virtual private network (VPN) with this step-by-step installation and configurat

Publisher: TechRepublic  |  Tags: authentication, html, network, server, vpn, windows server

Download this sample IT due diligence report template

Download this sample IT due diligence report template

Performing a technology due diligence is a good way to understand your client's technology and assess the financial impl

Publisher: TechRepublic  |  Tags: due diligence

Define project expectations with this criteria acceptance form

Define project expectations with this criteria acceptance form

Establishing acceptance criteria at the beginning of a project helps ensure that the results are well received. This sam

Publisher: TechRepublic  |  Tags: html