Relationship between characters and mathematical functions

select charset('你好')；
select concate('nihao', 'mysql','java');
select concat('你好')；
select instr('www.baidu.com', 'baidu');
Select ucase('abc');
Select lcase('ABC');
Select left('abcdefg',3);
Select length('abc');
select replace('www.baidu.com', 'baidu', 'qq');
select strcmp('abc','abc');
select strcmp('abc','ABC');
select substring('www.baidu.com ',3,5);
select ltrim(' abc');
select rtrim(' abc');
select length rtrim(' abc');
select length (rtrim(' abc'));
select abs(1);select abs(-1);
select bin(3);select ceiling(1.1);
select floor(1.1);
select conv(10, 10, 2);
select format(2.222333, 0);
select hex(10);
select least(2, 4, 5, 6, 10);
select mod(10, 3) ;
select rand(0,10);

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the php Chinese website!

Recommended reading:

How to sort according to the key value size of the array

Laravel implements multi-user authentication system

Real-time search prompt implemented in PHP

The above is the detailed content of Relationship between characters and mathematical functions. For more information, please follow other related articles on the PHP Chinese website!