Jump to content

PHP and MySQL query


SCook

Recommended Posts

Is there a way to query a sql table and compare a string without the case sensitivity being an issue?  For example, if I do this:

 

select * from companies where occupation like '%web%' and city like '%Orlando%' and state = 'FL';

 

I get nothing, but if I do this:

 

select * from companies where occupation like '%Web%' and city like '%Orlando%' and state = 'FL';

 

I get the desired result.  I realize this is more a sql question, but as this is part of a php search script, perhaps there's a solution.  Thanks.

Link to comment
https://forums.phpfreaks.com/topic/58274-php-and-mysql-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.