MySQL Query Help

Hi,

I'm not that great with MySQL but I was wondering if it were possible to compare strings with a database column where case doesn't matter.

For example, I have a string named "DiGiTAL PoInT". And in the database there is a string named "digital POINT".

How can I run a query that will return that there is a match?

select * from db where string="DiGiTAL PoInT";

I think this way looks for the exact string

 

I did a quick google search and it looks like what i'm looking for is the "LIKE" clause. Google works wonders. How dumb of me. Carry on.

 

you can make string to uppercase by using strtoupper() function in php and select all fields from mysql with using

select * from table

and with a while

you can compare the field from table with uppercaseing it if its the right one that matches with your string that uppercased before its the correct one ...


PS: If your table has soo many lines it works a bit slow. but about 8000 lines it works perfect.
PS2: If you need help in coding i may help. Pls ask for help.

 

That's all you need.

 

case insensitive:
select * from db where upper(string)=upper("DiGiTAL PoInT");