joquius Posted June 13, 2007 Share Posted June 13, 2007 I have a query which searches a mediawiki database, the problem being the case sensitive nature of the binary collation which is used for text revisions in mediawiki. I know that I could simply compare both lowercase, or ucfirst() the search string but it just lengthens the query. I would use regex, but I'm not to sure if pattern modifiers even exist in the regex that comes with MySQL 5.0. Oh and I'm definitely not changing the collation in the database itself. :-X Any help is appreciated Quote Link to comment https://forums.phpfreaks.com/topic/55391-mysql-case-sensitive-with-binary/ Share on other sites More sharing options...
bubblegum.anarchy Posted June 13, 2007 Share Posted June 13, 2007 SELECT * FROM table_name WHERE cast(column_name AS CHAR) LIKE 'search_term' Quote Link to comment https://forums.phpfreaks.com/topic/55391-mysql-case-sensitive-with-binary/#findComment-273796 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.