All pastes #253568 Raw Edit

deplifer

public text v1 · immutable
#253568 ·published 2006-11-20 21:58 UTC
rendered paste body
Problem....

1.- node.title is UPPER_CASE
2.- search string is LOWER_CASE

$q > SELECT DISTINCT ... FROM node INNER JOIN  ... WHERE node.title LIKE '%string%' ORDER BY node.title ASC
pager_query($q);

if i do an uppercase search it gives me an result.