Get DB-date, ignore Ucase and Lcase
Posted: Wed Mar 05, 2003 8:14 am
I've got this query:
їcode]$query2 = pg_exec($conn, "
SELECT
*
FROM
mtrade_forum
WHERE
threadcontent LIKE '%$searchstring%'
OR
threadtopic LIKE '%$searchstring%'
ORDER BY
createddate DESC
");
ї/code]
The problem is that it only shows results that contains words that match EXACTLY what is in $searchstring. If I search for "Test" I only get records that contain "Test".
I want it to ignore UpperCase and LowerCase, so If I search for "Test" I'll get "test", "TEST", "tEsT" and so on.
How do I do that?
Thanx in advance.
їcode]$query2 = pg_exec($conn, "
SELECT
*
FROM
mtrade_forum
WHERE
threadcontent LIKE '%$searchstring%'
OR
threadtopic LIKE '%$searchstring%'
ORDER BY
createddate DESC
");
ї/code]
The problem is that it only shows results that contains words that match EXACTLY what is in $searchstring. If I search for "Test" I only get records that contain "Test".
I want it to ignore UpperCase and LowerCase, so If I search for "Test" I'll get "test", "TEST", "tEsT" and so on.
How do I do that?
Thanx in advance.