mysql code

CREATE TABLE table_destination SELECT * FROM table_source ;

CREATE TABLE table_destination LIKE table_source ;
INSERT INTO table_destination SELECT * FROM table_source ;

to sql mysql by ki4ngel on May 13, 2008

SELECT * FROM texts WHERE content REGEXP '[^a-z]Hello[^a-z]' ;

If you really want to force a REGEXP comparison to be case sensitive, use the BINARY keyword to make one of the strings a binary string.

SELECT * FROM texts WHERE content REGEXP BINARY '[^a-zA-Z]Hello[^a-zA-Z]' ;

Warning: some characters do not work. Example :

SELECT * FROM texts WHERE content REGEXP '[^\w]Hello[^\w]' ;

to sql regex mysql by ki4ngel on Jan 19, 2008

So you can use this request MySQL before all others, for fix your problems :

...
mysql_query( "SET NAMES 'utf8' " );
...

function f_magic_quotes($text) {
	if ( !get_magic_quotes_gpc() ) {
		return addslashes($text);
	} else {
		return $text;
	}
}

function f_clean_quotes($text) {
	if ( !get_magic_quotes_gpc() ) {
		return $text;
	} else {
		return stripslashes($text);
	}
}

to sql mysql php text by ki4ngel on Nov 18, 2007