Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
knmwt15000
Forum Newbie
Posts: 8 Joined: Thu Apr 25, 2002 9:51 am
Post
by knmwt15000 » Tue May 28, 2002 6:06 am
Hi guys/gals,
When I try to do a search like
Code: Select all
select journal from journals where journal like "%jou%";
my database seems to be case sensative and only returns the %jou% and not %JOU%. it does not do this on all of my tables and on others it returns both jou and JOU entries
it should not do this does anyone have a clue how to fix it.
enygma
Site Admin
Posts: 175 Joined: Fri Apr 19, 2002 8:29 am
Location: Dallas, Tx
Post
by enygma » Tue May 28, 2002 7:46 am
you could always just do something like:
select journal from journals where upper(journal) like "%JOU%";
then, everything would be uppercase and you wouldn't have to worry about case-sensitive...
knmwt15000
Forum Newbie
Posts: 8 Joined: Thu Apr 25, 2002 9:51 am
Post
by knmwt15000 » Tue May 28, 2002 9:22 am
cheers,
I have used the solution making all upper case for now but I intend to use the first reply to get to the bottom of this.
tHANKS AGAIn