ChrisB: MySQL MATCH AGIANST CONCAT

Beitrag lesen

Hi,

(SELECT description FROM lkp_test WHERE MATCH (test_field) AGAINST (CONCAT('+', tbl_test.my_field, '*') IN BOOLEAN MODE)

liefert mir leider die Fehlermeldung:
Error Code : 1210
Incorrect arguments to AGAINST

Wadde hadde du denn an
AGAINST takes a string to search for, and an optional modifier that indicates what type of search to perform. The search string must be a literal string, not a variable or a column name.
nich' begrippst?

MfG ChrisB