Whats wrong with the WHERE clause in this query?

[RayYates]

Whats wrong with the WHERE clause in this query? Note: I think it works on MySQL and fails on Maria db.

SELECT CONCAT_WS( ' ', code, descrip ) AS search_string
FROM s01_Products 
WHERE search_string LIKE '%ceil%'

[burch]

It doesn't work for me in MySQL 4.1.22 or 5.5.33, but this query will:

SELECT * FROM ( SELECT CONCAT_WS( ' ', code, descrip ) AS search_string FROM s01_Products ) a WHERE search_string LIKE '%ceil%';

[RayYates]

Thx