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 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' 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
Archived
This topic is now archived and is closed to further replies.