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 '^(わ|を|ん|ワ|ヲ|ン)+';";