Case sensitivity

Anon

ok i'm doing a select:

select * from table where keywords like '%$searchtext%'

but if i search for 'the' it'll find stuff and when i search for 'THE' it won't?

fatal

try:

select * from table where lower(keywords) like '%$searchtext%';

fatal

hha, that made no sense 😛
try:

$searchtext = lower($searchtext);
select * from table where lower(keywords) like '%$searchtext%'

Anon

http://www.mysql.com/doc/S/t/String_comparison_functions.html

So: case sensitive

saloon12yrd

Snippet from the MySQL Manual:
"The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive fashion for BLOB values and case-insensitive fashion for TEXT values. In other words, a TEXT is a case-insensitive BLOB."

So, using TEXT instead of BLOB you don't need to LOWER() your query.

Greets,

Dominique

saloon12yrd

forgot the LIKE issue that parena mentioned... just forget it 🙂