I have a query for a search engine that I´m trying to optimize. What I need is to know which is the symbol for "any result" in the query, I´m actually using the %
symbol, but is not working
SELECT id,name,organizer_id,no_pages,publication_date,price,currency FROM reports AS T1, sector_index_reports AS T2, country_index_reports AS T3 WHERE
T2.id_cat ='%' AND (T1.id=T2.id_obiekt) AND T3.id_cat ='%' AND (T1.id=T3.id_obiekt) AND name LIKE '%construction%' ORDER BY date_published DESC
I need to make the query work when (T2.id_cat =) and (T3.id_cat =) when it has any value.
Thanks in advance