Posted by DR on 07/08/07 06:53

Is it possible to search within concatenated fields in mySQL?

This query works fine:

SELECT CONCAT(title, description) AS searchInMe FROM content

But when I try searching within 'searchInMe' I get an unknown column
error. This is the (Dreamweaver generated) query:

$query_search = sprintf("SELECT CONCAT(title, description) AS
searchInMe FROM content WHERE searchInMe LIKE '%%%s%%'",
$searchTerm_search);

Is it that I cannot search within concatenated fields?

Many thanks,

Dmitri

[Back to original message]