Mysqlで50音検索(あ行からわ行まで)
コピペ用です。
$query = "SELECT * FROM example WHERE name REGEXP '^(あ|い|う|え|お|ア|イ|ウ|エ|オ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(か|き|く|け|こ|カ|キ|ク|ケ|コ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(さ|し|す|せ|そ|サ|シ|ス|セ|ソ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(た|ち|つ|て|と|タ|チ|ツ|テ|ト)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(な|に|ぬ|ね|の|ナ|二|ヌ|ネ|ノ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(は|ひ|ふ|へ|ほ|ハ|ヒ|フ|ヘ|ホ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(ま|み|む|め|も|マ|ミ|ム|メ|モ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(や|ゆ|よ|ヤ|ユ|ヨ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(ら|り|る|れ|ろ|ラ|リ|ル|レ|ロ)+';";
$query = "SELECT * FROM example WHERE name REGEXP '^(わ|を|ん|ワ|ヲ|ン)+';";
Author And Source
この問題について(Mysqlで50音検索(あ行からわ行まで)), 我々は、より多くの情報をここで見つけました https://qiita.com/Hiaruronnsann/items/4218a9e885d02ff1ff89著者帰属:元の著者の情報は、元のURLに含まれています。著作権は原作者に属する。
Content is automatically searched and collected through network algorithms . If there is a violation . Please contact us . We will adjust (correct author information ,or delete content ) as soon as possible .