How do i do a case insensitive mysql contains string

Question

I am doing a query that needs to search if the work software is in the string...the only problem is that it maybe upper or lower case so i was thinking of doing this

and (cd.name LIKE '%software%' or cd.name LIKE '%Software%' )

but i feel like there is another way if anyone knows

Possibly "%oftware%"? Of course that might clash with any number of similarities... — Corey Ogburn
– Corey Ogburn, Commented Aug 3, 2011 at 20:48

Parris Varney · Accepted Answer · 2011-08-03 20:47:25Z

8

MySQL is case insensitive.

These will give the same results, so you can use either: cd.name LIKE '%software%' cd.name LIKE '%Software%'

That's what the 'ci' is for in the different collations (latin1_general_ci, latin1_swedish_ci)

answered Aug 3, 2011 at 20:47

Parris Varney

11.5k12 gold badges49 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mchl Over a year ago

unless its a *_bin collation, but you can still specify which collation should be used in the query, even if column in question uses case sensitive one.

Matt Elhotiby · Accepted Answer · 2011-08-03 20:53:15Z

8

You can always try

LOWER(cd.name) LIKE '%software%'

answered Aug 3, 2011 at 20:53

Matt Elhotiby

44.2k91 gold badges225 silver badges328 bronze badges

2 Comments

parsecer Over a year ago

How to use it with a Python query string?

Zexelon Over a year ago

@parsecer, this is worth its own question. If crating your own SQL string you can use the SQL LOWER function in it. If you are doing a parameter based query, just use Python's string.lower() to lower case the string before feeding it into the parameter.

Collectives™ on Stack Overflow

How do i do a case insensitive mysql contains string

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related