mysql 里兑现查询汉字的拼音首字母
mysql 里实现查询汉字的拼音首字母
哪位大侠 给我个 mysql 里实现查询汉字的拼音首字母 能用的
------解决方案--------------------
http://topic.csdn.net/u/20090611/17/7579BB9A-0A7C-4460-A302-10BAE7F4A9C5.html
------解决方案--------------------
function getfirstchar($s0){
if($s0[0]=='I' || $s[0]=='i'){
return "I";
}elseif($s0[0]=='U' || $s[0]=='u'){
return 'U';
}elseif($s0[0]=='V' || $s[0]=='v'){
return 'V';
}else{
$fchar = ord($s0{0});
if($fchar >= ord("A") and $fchar $s1 = iconv("UTF-8","gb2312", $s0);
$s2 = iconv("gb2312","UTF-8", $s1);
if($s2 == $s0){$s = $s1;}else{$s = $s0;}
$asc = ord($s{0}) * 256 + ord($s{1}) - 65536;
if($asc >= -20319 and $asc if($asc >= -20283 and $asc if($asc >= -19775 and $asc if($asc >= -19218 and $asc if($asc >= -18710 and $asc if($asc >= -18526 and $asc if($asc >= -18239 and $asc if($asc >= -17922 and $asc if($asc >= -17417 and $asc if($asc >= -16474 and $asc if($asc >= -16212 and $asc if($asc >= -15640 and $asc if($asc >= -15165 and $asc if($asc >= -14922 and $asc if($asc >= -14914 and $asc if($asc >= -14630 and $asc if($asc >= -14149 and $asc if($asc >= -14090 and $asc if($asc >= -13318 and $asc if($asc >= -12838 and $asc if($asc >= -12556 and $asc if($asc >= -11847 and $asc if($asc >= -11055 and $asc return null;
}
}
这是我之前的做的，希望可以帮到您！
------解决方案--------------------
那不就结了
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1377
52
How to write if in c language to judge multiple conditions
Mar 25, 2024 pm 03:24 PM
In C language, if statement is usually used to execute a specific block of code based on a single condition. However, multiple conditions can be combined to make a determination using logical operators such as &&, ||, and !. Including using logical AND (&&) to judge multiple conditions, using logical OR (||) to judge at least one condition, using logical NOT (!) to judge the negation of a single condition, as well as nesting if statements and using parentheses to clarify priority.
Detailed explanation of the usage of return in C language
Oct 07, 2023 am 10:58 AM
The usage of return in C language is: 1. For functions whose return value type is void, you can use the return statement to end the execution of the function early; 2. For functions whose return value type is not void, the function of the return statement is to end the execution of the function. The result is returned to the caller; 3. End the execution of the function early. Inside the function, we can use the return statement to end the execution of the function early, even if the function does not return a value.
What is the execution order of return and finally statements in Java?
Apr 25, 2023 pm 07:55 PM
Source code: publicclassReturnFinallyDemo{publicstaticvoidmain(String[]args){System.out.println(case1());}publicstaticintcase1(){intx;try{x=1;returnx;}finally{x=3;}}}#Output The output of the above code can simply conclude: return is executed before finally. Let's take a look at what happens at the bytecode level. The following intercepts part of the bytecode of the case1 method, and compares the source code to annotate the meaning of each instruction in
How to use if nested statements in MySQL stored procedures
May 26, 2023 pm 12:07 PM
1. Introduction to if statement The if statement is a branching structure statement that performs different operations according to conditions. The if statement usually consists of a conditional expression and one or more statements. If the value of the conditional expression is true, then the statements in the if statement are executed; otherwise, the if statement block is skipped. The syntax of the if statement is as follows: if(condition)thenstatement;elsestatement;endif; where condition is the conditional expression and statement is the SQL statement that needs to be executed. 2. Introduction to if nested statements An if nested statement refers to nesting one or more if statement blocks within an if statement block to perform different operations based on different conditions.
php提交表单通过后,弹出的对话框怎样在当前页弹出,该如何解决
Jun 13, 2016 am 10:23 AM
php提交表单通过后,弹出的对话框怎样在当前页弹出php提交表单通过后,弹出的对话框怎样在当前页弹出而不是在空白页弹出？想实现这样的效果：而不是空白页弹出:------解决方案--------------------如果你的验证用PHP在后端，那么就用Ajax；仅供参考：HTML code
How to use if statement in Python?
Apr 20, 2023 pm 11:40 PM
How to use the if statement in Python The if statement is used to express a possible situation and how to handle the situation. The if statement can be used to express one possibility, two possibilities, or multiple possibilities. 1 A possibility A single if statement represents a possibility. The if keyword is followed by an expression. When the expression is True, it means that this situation has occurred, and the specified statement is executed, that is, the situation is handled, as shown in the figure 1 shown. Figure 1 The use of a single if statement. Figure 1① Use the input() function to receive the value input by the user, convert it into int type and save it in a variable; Figure 1② Use the if statement to judge the variable x. If the value of x is greater than 0, the message "You entered a non-negative number" is output (
How does Vue3 use setup syntax sugar to refuse to write return
May 12, 2023 pm 06:34 PM
Vue3.2 setup syntax sugar is a compile-time syntax sugar that uses the combined API in a single file component (SFC) to solve the cumbersome setup in Vue3.0. The declared variables, functions, and content introduced by import are exposed through return, so that they can be used in Vue3.0. Problems in use 1. There is no need to return declared variables, functions and content introduced by import during use. You can use syntactic sugar //import the content introduced import{getToday}from'./utils'//variable constmsg='Hello !'//function func
Detailed explanation of JavaScript function return values and return statements
Aug 04, 2022 am 09:46 AM
JavaScript functions provide two interfaces to interact with the outside world. The parameters serve as the entrance to receive external information; the return value serves as the outlet to feed back the operation results to the outside world. The following article will take you to understand the JavaScript function return value and briefly analyze the usage of the return statement. I hope it will be helpful to you!
