{"id":74505,"date":"2026-02-09T23:25:32","date_gmt":"2026-02-09T15:25:32","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/74505.html"},"modified":"2026-02-09T23:25:32","modified_gmt":"2026-02-09T15:25:32","slug":"mysql%e6%ad%a3%e5%88%99%e8%a1%a8%e8%be%be%e5%bc%8f%e6%a8%a1%e7%b3%8a%e6%9f%a5%e8%af%a2%e5%ae%8c%e5%85%a8%e6%8c%87%e5%8d%97%ef%bc%9a%e8%ae%a9%e6%95%b0%e6%8d%ae%e6%9f%a5%e6%89%be%e6%9b%b4%e6%99%ba","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/74505.html","title":{"rendered":"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd"},"content":{"rendered":"

📖 \u524d\u8a00：\u4e3a\u4ec0\u4e48\u9700\u8981\u6b63\u5219\u8868\u8fbe\u5f0f？<\/h2>\n

\u5728\u65e5\u5e38\u5f00\u53d1\u4e2d，\u4f60\u662f\u5426\u9047\u5230\u8fc7\u8fd9\u6837\u7684\u70e6\u607c？<\/p>\n

\u67e5\u627e\u6240\u6709\u4ee5"139"\u5f00\u5934\u7684\u624b\u673a\u53f7<\/p>\n

\u9a8c\u8bc1\u90ae\u7bb1\u683c\u5f0f\u662f\u5426\u6b63\u786e<\/p>\n

\u63d0\u53d6\u6587\u672c\u4e2d\u7684\u65e5\u671f\u4fe1\u606f<\/p>\n

\u5339\u914d\u7279\u5b9a\u683c\u5f0f\u7684\u8eab\u4efd\u8bc1\u53f7<\/p>\n

\u4f20\u7edf\u7684 LIKE \u64cd\u4f5c\u7b26\u5728\u8fd9\u4e9b\u590d\u6742\u573a\u666f\u4e0b\u529b\u4e0d\u4ece\u5fc3，\u800c\u6b63\u5219\u8868\u8fbe\u5f0f\u5c31\u662f\u89e3\u51b3\u8fd9\u4e9b\u95ee\u9898\u7684\u745e\u58eb\u519b\u5200！<\/p>\n

🎯 \u7b2c\u4e00\u7ae0：\u6b63\u5219\u8868\u8fbe\u5f0f\u57fa\u7840\u5165\u95e8<\/h2>\n

1.1 \u4ec0\u4e48\u662f\u6b63\u5219\u8868\u8fbe\u5f0f？<\/h4>\n

\u6b63\u5219\u8868\u8fbe\u5f0f（Regular Expression）\u662f\u4e00\u79cd\u7528\u4e8e\u63cf\u8ff0\u5b57\u7b26\u4e32\u6a21\u5f0f\u7684\u5f3a\u5927\u5de5\u5177\u3002\u60f3\u8c61\u4e00\u4e0b：<\/p>\n

LIKE \u2018%abc%\u2019 \u53ea\u80fd\u627e\u5305\u542b"abc"\u7684\u5b57\u7b26\u4e32<\/p>\n

\u6b63\u5219\u8868\u8fbe\u5f0f\u53ef\u4ee5\u627e："\u4ee5a\u5f00\u5934，\u4e2d\u95f4\u662f\u4efb\u610f\u6570\u5b57，\u4ee5c\u7ed3\u5c3e"\u7684\u5b57\u7b26\u4e32<\/p>\n

1.2 MySQL\u4e2d\u7684\u6b63\u5219\u8868\u8fbe\u5f0f\u51fd\u6570<\/h4>\n

MySQL\u63d0\u4f9b\u4e86\u4e24\u4e2a\u4e3b\u8981\u7684\u6b63\u5219\u8868\u8fbe\u5f0f\u51fd\u6570：
\n\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

🔧 \u7b2c\u4e8c\u7ae0：REGEXP\u57fa\u7840\u5339\u914d<\/h2>\n

2.1 \u6700\u7b80\u5355\u7684\u5339\u914d：\u67e5\u627e\u5305\u542b\u7279\u5b9a\u6587\u672c\u7684\u8bb0\u5f55<\/h4>\n

sql
\n— \u4f20\u7edfLIKE\u5199\u6cd5
\nSELECT * FROM users<\/span>
\nWHERE username LIKE '%admin%'<\/span>;<\/span><\/p>\n

— \u4f7f\u7528\u6b63\u5219\u8868\u8fbe\u5f0f（\u66f4\u76f4\u89c2）
\nSELECT * FROM users<\/span>
\nWHERE username REGEXP 'admin'<\/span>;<\/span><\/p>\n

— \u4e24\u8005\u7684\u533a\u522b：
\n— LIKE '%admin%'<\/span> \u53ef\u4ee5\u5339\u914d：superadmin\u3001admin123\u3001myadmin
\n— REGEXP 'admin'<\/span> \u53ef\u4ee5\u5339\u914d：admin\u3001administrator\u3001badmin（\u540c\u6837\u5339\u914d！）<\/p>\n

2.2 \u5339\u914d\u5f00\u5934\u548c\u7ed3\u5c3e<\/h4>\n

sql
\n— \u67e5\u627e\u4ee5"\u5f20"<\/span>\u5f00\u5934\u7684\u59d3\u540d
\nSELECT * FROM employees
\nWHERE name REGEXP '^\u5f20'<\/span>;<\/span><\/p>\n

— \u67e5\u627e\u4ee5"com"<\/span>\u7ed3\u5c3e\u7684\u90ae\u7bb1
\nSELECT * FROM users<\/span>
\nWHERE email REGEXP 'com$'<\/span>;<\/span><\/p>\n

— \u67e5\u627e\u4ee5"139"<\/span>\u5f00\u5934\u7684\u624b\u673a\u53f7
\nSELECT * FROM customers
\nWHERE phone REGEXP '^139'<\/span>;<\/span><\/p>\n

— \u7cbe\u786e\u5339\u914d"hello"<\/span>（\u5f00\u5934\u5230\u7ed3\u5c3e\u90fd\u662fhello）
\nSELECT * FROM messages
\nWHERE content REGEXP '^hello$'<\/span>;<\/span><\/p>\n

📊 \u5bf9\u6bd4\u8868：\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

2.3 \u5339\u914d\u591a\u4e2a\u5b57\u7b26\u4e4b\u4e00<\/h4>\n

sql
\n— \u67e5\u627e\u59d3"\u5f20"<\/span>\u6216"\u738b"<\/span>\u7684\u5458\u5de5
\nSELECT * FROM employees
\nWHERE name REGEXP '^[\u5f20\u738b]'<\/span>;<\/span><\/p>\n

— \u67e5\u627e\u5305\u542b\u6570\u5b570-5\u7684\u7535\u8bdd
\nSELECT * FROM contacts
\nWHERE phone REGEXP '[0-5]'<\/span>;<\/span><\/p>\n

— \u67e5\u627e\u5143\u97f3\u5b57\u6bcd\u5f00\u5934\u7684\u5355\u8bcd
\nSELECT * FROM articles
\nWHERE title REGEXP '^[aeiouAEIOU]'<\/span>;<\/span><\/p>\n

— \u6392\u9664\u6027\u5339\u914d：\u67e5\u627e\u4e0d\u662f\u6570\u5b57\u7684\u5b57\u7b26
\nSELECT * FROM logs
\nWHERE message REGEXP '[^0-9]'<\/span>;<\/span> — ^\u5728[<\/span>]<\/span>\u5185\u8868\u793a"\u975e"<\/span><\/p>\n

🔍 \u5b57\u7b26\u96c6\u8bf4\u660e：<\/p>\n

[abc]：\u5339\u914da\u3001b\u6216c\u4e2d\u7684\u4efb\u610f\u4e00\u4e2a<\/p>\n

[a-z]：\u5339\u914d\u4efb\u610f\u5c0f\u5199\u5b57\u6bcd<\/p>\n

[A-Z]：\u5339\u914d\u4efb\u610f\u5927\u5199\u5b57\u6bcd<\/p>\n

[0-9]：\u5339\u914d\u4efb\u610f\u6570\u5b57<\/p>\n

[^abc]：\u5339\u914d\u9664\u4e86a\u3001b\u3001c\u4e4b\u5916\u7684\u5b57\u7b26<\/p>\n

\u2699\ufe0f \u7b2c\u4e09\u7ae0：\u9ad8\u7ea7\u5339\u914d\u6280\u5de7<\/h2>\n

3.1 \u91cd\u590d\u5339\u914d：\u63a7\u5236\u5b57\u7b26\u51fa\u73b0\u6b21\u6570<\/h4>\n

sql
\n— \u7cbe\u786e\u5339\u914d：\u5305\u542b3\u4e2a\u8fde\u7eed\u6570\u5b57
\nSELECT * FROM products
\nWHERE product_code REGEXP '[0-9]{3}'<\/span>;<\/span><\/p>\n

— \u8303\u56f4\u5339\u914d：2\u52304\u4e2a\u6570\u5b57
\nSELECT * FROM orders
\nWHERE order_no REGEXP '[0-9]{2,4}'<\/span>;<\/span><\/p>\n

— \u81f3\u5c11\u5339\u914d：3\u4e2a\u6216\u66f4\u591a\u5b57\u6bcd
\nSELECT * FROM books
\nWHERE isbn REGEXP '[A-Z]{3,}'<\/span>;<\/span><\/p>\n

— \u53ef\u9009\u5339\u914d：0\u4e2a\u62161\u4e2a\u5b57\u6bcd
\nSELECT * FROM files
\nWHERE filename REGEXP 'backup_[0-9]?\\\\.sql'<\/span>;<\/span><\/p>\n

— \u4e00\u4e2a\u6216\u591a\u4e2a：\u5339\u914d\u8fde\u7eed\u7684\u6570\u5b57
\nSELECT * FROM logs
\nWHERE log_id REGEXP '[0-9]+'<\/span>;<\/span><\/p>\n

— \u96f6\u4e2a\u6216\u591a\u4e2a：\u5339\u914d\u53ef\u80fd\u7684\u524d\u7f00
\nSELECT * FROM configs
\nWHERE key_name REGEXP 'debug_.*'<\/span>;<\/span><\/p>\n

🎯 \u91cd\u590d\u5339\u914d\u7b26\u901f\u67e5\u8868：\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

3.2 \u5206\u7ec4\u548c\u9009\u62e9<\/h4>\n

sql
\n— \u5339\u914d"\u533a\u53f7-\u7535\u8bdd\u53f7\u7801"<\/span>\u683c\u5f0f
\nSELECT * FROM contacts
\nWHERE phone REGEXP '^([0-9]{3,4})-([0-9]{7,8})$'<\/span>;<\/span><\/p>\n

— \u67e5\u627e\u591a\u79cd\u65e5\u671f\u683c\u5f0f
\nSELECT * FROM documents
\nWHERE date_string REGEXP '(202[0-9]-[0-9]{2}-[0-9]{2})|([0-9]{2}\/[0-9]{2}\/202[0-9])'<\/span>;<\/span><\/p>\n

— \u5206\u7ec4\u63d0\u53d6（MySQL 8.0<\/span>+）
\nSELECT
\n phone,
\n REGEXP_SUBSTR(<\/span>phone, '^([0-9]{3,4})-([0-9]{7,8})$'<\/span>, 1<\/span>, 1<\/span>, ''<\/span>, 1<\/span>)<\/span> as area_code,
\n REGEXP_SUBSTR(<\/span>phone, '^([0-9]{3,4})-([0-9]{7,8})$'<\/span>, 1<\/span>, 1<\/span>, ''<\/span>, 2<\/span>)<\/span> as phone_number
\nFROM contacts
\nWHERE phone REGEXP '^[0-9]{3,4}-[0-9]{7,8}$'<\/span>;<\/span><\/p>\n

3.3 \u7279\u6b8a\u5b57\u7b26\u548c\u8f6c\u4e49<\/h4>\n

sql
\n— \u5339\u914d\u70b9\u53f7（\u9700\u8981\u8f6c\u4e49）
\nSELECT * FROM files
\nWHERE filename REGEXP '\\\\.txt$'<\/span>;<\/span><\/p>\n

— \u5339\u914d\u5305\u542b\u65b9\u62ec\u53f7\u7684\u5185\u5bb9
\nSELECT * FROM logs
\nWHERE message REGEXP '\\\\\\\\[error\\\\\\\\]'<\/span>;<\/span><\/p>\n

\u2013 \u5e38\u7528\u7279\u6b8a\u5b57\u7b26\u8f6c\u4e49
\n\/*
\n. \u5339\u914d\u70b9\u53f7
\n* \u5339\u914d\u661f\u53f7
\n+ \u5339\u914d\u52a0\u53f7
\n? \u5339\u914d\u95ee\u53f7
\n\\\\ \u5339\u914d\u53cd\u659c\u6760
\n$ \u5339\u914d\u7f8e\u5143\u7b26\u53f7
\n^ \u5339\u914d\u8131\u5b57\u7b26
\n[ \u5339\u914d\u5de6\u65b9\u62ec\u53f7
\n] \u5339\u914d\u53f3\u65b9\u62ec\u53f7
\n( \u5339\u914d\u5de6\u62ec\u53f7
\n) \u5339\u914d\u53f3\u62ec\u53f7
\n*\/<\/p>\n

💼 \u7b2c\u56db\u7ae0：\u5b9e\u6218\u5e94\u7528\u573a\u666f<\/h2>\n

4.1 \u6570\u636e\u9a8c\u8bc1：\u786e\u4fdd\u6570\u636e\u8d28\u91cf<\/h4>\n

sql
\n— \u9a8c\u8bc1\u90ae\u7bb1\u683c\u5f0f
\nSELECT email,
\n CASE
\n WHEN email REGEXP '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\\\.[A-Za-z]{2,}$'<\/span>
\n THEN '\u6709\u6548\u90ae\u7bb1'<\/span>
\n ELSE '\u65e0\u6548\u90ae\u7bb1'<\/span>
\n END as validation_result
\nFROM users<\/span>;<\/span><\/p>\n

— \u9a8c\u8bc1\u624b\u673a\u53f7（\u4e2d\u56fd\u5927\u9646）
\nSELECT phone,
\n CASE
\n WHEN phone REGEXP '^1[3-9][0-9]{9}$'<\/span> THEN '\u6709\u6548\u624b\u673a\u53f7'<\/span>
\n WHEN phone REGEXP '^[0-9]{3,4}-[0-9]{7,8}$'<\/span> THEN '\u6709\u6548\u5ea7\u673a'<\/span>
\n ELSE '\u65e0\u6548\u53f7\u7801'<\/span>
\n END as phone_type
\nFROM customers;<\/span><\/p>\n

— \u9a8c\u8bc1\u8eab\u4efd\u8bc1\u53f7（\u7b80\u5355\u7248）
\nSELECT id_card,
\n CASE
\n WHEN id_card REGEXP '^[1-9][0-9]{5}(18|19|20)[0-9]{2}(0[1-9]|1[0-2])(0[1-9]|[1-2][0-9]|3[0-1])[0-9]{3}[0-9Xx]$'<\/span>
\n THEN '\u683c\u5f0f\u6b63\u786e'<\/span>
\n ELSE '\u683c\u5f0f\u9519\u8bef'<\/span>
\n END as id_validation
\nFROM person_info;<\/span><\/p>\n

4.2 \u6570\u636e\u6e05\u6d17：\u5904\u7406\u6742\u4e71\u6570\u636e<\/h4>\n

sql
\n— \u63d0\u53d6\u7eaf\u6570\u5b57\u5185\u5bb9
\nSELECT
\n content,
\n REGEXP_REPLACE(<\/span>content, '[^0-9]'<\/span>, ''<\/span>)<\/span> as numbers_only
\nFROM mixed_data;<\/span><\/p>\n

— \u6e05\u7406\u591a\u4f59\u7a7a\u683c
\nSELECT
\n address,
\n REGEXP_REPLACE(<\/span>address, '\\\\\\\\s+'<\/span>, ' '<\/span>)<\/span> as cleaned_address
\nFROM customer_address;<\/span><\/p>\n

— \u6807\u51c6\u5316\u65e5\u671f\u683c\u5f0f
\nSELECT
\n original_date,
\n CASE
\n WHEN original_date REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2}$'<\/span> THEN original_date
\n WHEN original_date REGEXP '^[0-9]{2}\/[0-9]{2}\/[0-9]{4}$'<\/span>
\n THEN CONCAT(<\/span>
\n SUBSTRING_INDEX(<\/span>SUBSTRING_INDEX(<\/span>original_date, '\/'<\/span>, -1)<\/span>, '\/'<\/span>, 1<\/span>)<\/span>,
\n '-'<\/span>,
\n LPAD(<\/span>SUBSTRING_INDEX(<\/span>original_date, '\/'<\/span>, 1<\/span>)<\/span>, 2<\/span>, '0'<\/span>)<\/span>,
\n '-'<\/span>,
\n LPAD(<\/span>SUBSTRING_INDEX(<\/span>SUBSTRING_INDEX(<\/span>original_date, '\/'<\/span>, 2<\/span>)<\/span>, '\/'<\/span>, -1)<\/span>, 2<\/span>, '0'<\/span>)<\/span>
\n )<\/span>
\n ELSE NULL
\n END as standard_date
\nFROM dates_table;<\/span><\/p>\n

4.3 \u65e5\u5fd7\u5206\u6790：\u63d0\u53d6\u5173\u952e\u4fe1\u606f<\/h4>\n

sql
\n— \u4ece\u65e5\u5fd7\u4e2d\u63d0\u53d6IP\u5730\u5740
\nSELECT
\n log_entry,
\n REGEXP_SUBSTR(<\/span>log_entry, '[0-9]{1,3}\\\\\\\\.[0-9]{1,3}\\\\\\\\.[0-9]{1,3}\\\\\\\\.[0-9]{1,3}'<\/span>)<\/span> as ip_address
\nFROM server_logs
\nWHERE log_entry REGEXP '[0-9]{1,3}\\\\\\\\.[0-9]{1,3}\\\\\\\\.[0-9]{1,3}\\\\\\\\.[0-9]{1,3}'<\/span>;<\/span><\/p>\n

— \u63d0\u53d6\u9519\u8bef\u7ea7\u522b
\nSELECT
\n log_entry,
\n CASE
\n WHEN log_entry REGEXP '\\\\\\\\[(ERROR|FATAL)\\\\\\\\]'<\/span> THEN '\u4e25\u91cd\u9519\u8bef'<\/span>
\n WHEN log_entry REGEXP '\\\\\\\\[WARNING\\\\\\\\]'<\/span> THEN '\u8b66\u544a'<\/span>
\n WHEN log_entry REGEXP '\\\\\\\\[INFO\\\\\\\\]'<\/span> THEN '\u4fe1\u606f'<\/span>
\n ELSE '\u672a\u77e5\u7ea7\u522b'<\/span>
\n END as log_level
\nFROM application_logs;<\/span><\/p>\n

— \u63d0\u53d6\u65f6\u95f4\u6233\u548c\u6d88\u606f
\nSELECT
\n log_entry,
\n REGEXP_SUBSTR(<\/span>log_entry, '\\\\\\\\[[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}\\\\\\\\]'<\/span>)<\/span> as timestamp,
\n REGEXP_REPLACE(<\/span>log_entry, '^.*\\\\\\\\] '<\/span>, ''<\/span>)<\/span> as message
\nFROM system_logs;<\/span><\/p>\n

🚀 \u7b2c\u4e94\u7ae0：\u6027\u80fd\u4f18\u5316\u4e0e\u6700\u4f73\u5b9e\u8df5<\/h2>\n

5.1 \u521b\u5efa\u6b63\u5219\u8868\u8fbe\u5f0f\u7d22\u5f15（\u865a\u62df\u5217）<\/h4>\n

sql
\n— \u521b\u5efa\u865a\u62df\u5217\u5b58\u50a8\u63d0\u53d6\u7684\u4fe1\u606f
\nALTER TABLE users<\/span>
\nADD COLUMN email_domain VARCHAR(<\/span>100<\/span>)<\/span>
\nGENERATED ALWAYS AS (<\/span>
\n REGEXP_SUBSTR(<\/span>email, '@([A-Za-z0-9.-]+)$'<\/span>, 1<\/span>, 1<\/span>, ''<\/span>, 1<\/span>)<\/span>
\n)<\/span> STORED;<\/span><\/p>\n

— \u5728\u865a\u62df\u5217\u4e0a\u521b\u5efa\u7d22\u5f15
\nCREATE INDEX idx_email_domain ON users(<\/span>email_domain)<\/span>;<\/span><\/p>\n

— \u73b0\u5728\u53ef\u4ee5\u5feb\u901f\u67e5\u8be2\u7279\u5b9a\u57df\u540d\u7684\u7528\u6237
\nSELECT * FROM users<\/span> WHERE email_domain =<\/span> 'gmail.com'<\/span>;<\/span><\/p>\n

5.2 \u907f\u514d\u6027\u80fd\u9677\u9631<\/h4>\n

sql
\n— \u274c \u907f\u514d\u8fc7\u5ea6\u590d\u6742\u7684\u6b63\u5219\u8868\u8fbe\u5f0f
\nSELECT * FROM large_table
\nWHERE content REGEXP '^([a-z]+)\\\\\\\\1{10,}'<\/span>;<\/span> — \u53ef\u80fd\u5f88\u6162！<\/p>\n

— \u2705 \u5c3d\u91cf\u4f7f\u7528\u66f4\u7b80\u5355\u7684\u6a21\u5f0f
\nSELECT * FROM large_table
\nWHERE content REGEXP 'aaaaaaaaaaa'<\/span>;<\/span> — \u66f4\u9ad8\u6548<\/p>\n

— \u274c \u907f\u514d\u5728\u5f00\u5934\u4f7f\u7528\u901a\u914d\u7b26
\nSELECT * FROM users<\/span>
\nWHERE username REGEXP '.*admin'<\/span>;<\/span> — \u626b\u63cf\u5168\u8868<\/p>\n

— \u2705 \u5c3d\u91cf\u951a\u5b9a\u5f00\u5934
\nSELECT * FROM users<\/span>
\nWHERE username REGEXP '^admin.*'<\/span>;<\/span> — \u53ef\u4ee5\u4f7f\u7528\u7d22\u5f15<\/p>\n

5.3 \u5b9e\u7528\u6280\u5de7\u548c\u5c0f\u8d34\u58eb<\/h4>\n

sql
\n—<\/span> 1.<\/span> \u6d4b\u8bd5\u6b63\u5219\u8868\u8fbe\u5f0f（\u5148SELECT\u540eWHERE）
\nSELECT 'test@example.com'<\/span> REGEXP '^<\/span>[<\/span>A–<\/span>Za–<\/span>z0–<\/span>9.<\/span>_%<\/span>+<\/span>–<\/span>]<\/span>+<\/span>@[<\/span>A–<\/span>Za–<\/span>z0–<\/span>9.<\/span>–<\/span>]<\/span>+<\/span>\\\\.<\/span>[<\/span>A–<\/span>Za–<\/span>z]<\/span>{<\/span>2<\/span>,<\/span>}<\/span>$' as is_valid;<\/span><\/p>\n

—<\/span> 2.<\/span> \u4f7f\u7528\u53d8\u91cf\u5b58\u50a8\u590d\u6742\u6b63\u5219\u8868\u8fbe\u5f0f
\nSET @phone_regex =<\/span> '^1[3-9][0-9]{9}$'<\/span>;<\/span>
\nSELECT *<\/span> FROM customers WHERE phone REGEXP @phone_regex;<\/span><\/p>\n

—<\/span> 3.<\/span> \u7ec4\u5408\u4f7f\u7528LIKE\u548cREGEXP
\nSELECT *<\/span> FROM products
\nWHERE
\n —<\/span> \u5148\u7528LIKE\u8fc7\u6ee4\u5927\u90e8\u5206\u6570\u636e（\u5feb）
\n description LIKE '%\u6298\u6263%'<\/span>
\n AND
\n —<\/span> \u518d\u7528REGEXP\u7cbe\u786e\u5339\u914d（\u51c6）
\n description REGEXP '\u9650\u65f6\u6298\u6263[0-9]{1,2}%'<\/span>;<\/span><\/p>\n

—<\/span> 4.<\/span> \u6b63\u5219\u8868\u8fbe\u5f0f\u8c03\u8bd5\u51fd\u6570
\nSELECT
\n REGEXP_INSTR<\/span>(<\/span>'hello123world'<\/span>,<\/span> '[0-9]+'<\/span>)<\/span> as match_position,<\/span> —<\/span> \u8fd4\u56de6<\/span>
\n REGEXP_SUBSTR<\/span>(<\/span>'hello123world'<\/span>,<\/span> '[0-9]+'<\/span>)<\/span> as match_string,<\/span> —<\/span> \u8fd4\u56de"123"<\/span>
\n REGEXP_REPLACE<\/span>(<\/span>'hello123world'<\/span>,<\/span> '[0-9]+'<\/span>,<\/span> '###'<\/span>)<\/span> as replaced_string;<\/span> —<\/span> "hello###world"<\/span><\/p>\n

📊 \u7b2c\u516d\u7ae0：REGEXP vs LIKE \u5168\u9762\u5bf9\u6bd4<\/h2>\n

6.1 \u529f\u80fd\u5bf9\u6bd4\u8868\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/h4>\n

6.2 \u4f7f\u7528\u573a\u666f\u5efa\u8bae<\/h4>\n

sql
\n— \u573a\u666f1：\u7b80\u5355\u524d\u7f00\u5339\u914d（\u63a8\u8350LIKE）
\n— LIKE\u7248\u672c（\u66f4\u5feb）
\nSELECT * FROM products WHERE name LIKE 'Apple%'<\/span>;<\/span><\/p>\n

— REGEXP\u7248\u672c
\nSELECT * FROM products WHERE name REGEXP '^Apple'<\/span>;<\/span><\/p>\n

— \u573a\u666f2：\u590d\u6742\u6a21\u5f0f\u5339\u914d（\u5fc5\u987b\u7528REGEXP）
\n— \u67e5\u627e\u5305\u542b3\u4e2a\u8fde\u7eed\u6570\u5b57\u7684\u4ea7\u54c1\u7f16\u7801
\nSELECT * FROM products WHERE code REGEXP '[0-9]{3}'<\/span>;<\/span>
\n— LIKE\u65e0\u6cd5\u5b9e\u73b0！<\/p>\n

— \u573a\u666f3：\u6df7\u5408\u4f7f\u7528（\u6700\u4f73\u5b9e\u8df5）
\n— \u5148\u7528LIKE\u5feb\u901f\u8fc7\u6ee4，\u518d\u7528REGEXP\u7cbe\u786e\u5339\u914d
\nSELECT * FROM logs
\nWHERE
\n message LIKE '%error%'<\/span> — \u5feb\u901f\u8fc7\u6ee4
\n AND message REGEXP 'error:[0-9]{4}'<\/span>;<\/span> — \u7cbe\u786e\u5339\u914d<\/p>\n

🎉 \u603b\u7ed3\u4e0e\u8fdb\u9636\u5efa\u8bae<\/h2>\n

\u6838\u5fc3\u8981\u70b9\u56de\u987e
\n\u2705 REGEXP\u6bd4LIKE\u66f4\u5f3a\u5927，\u9002\u5408\u590d\u6742\u6a21\u5f0f\u5339\u914d<\/p>\n

\u2705 \u5148\u6d4b\u8bd5\u540e\u4f7f\u7528，\u590d\u6742\u6b63\u5219\u5148\u5728\u5de5\u5177\u4e2d\u6d4b\u8bd5<\/p>\n

\u2705 \u6ce8\u610f\u6027\u80fd\u5f71\u54cd，\u5927\u6570\u636e\u8868\u614e\u7528\u6b63\u5219<\/p>\n

\u2705 \u5408\u7406\u4f7f\u7528\u7d22\u5f15，\u865a\u62df\u5217\u662f\u6027\u80fd\u4f18\u5316\u7684\u5229\u5668<\/p>\n

\u2705 \u4fdd\u6301\u6b63\u5219\u7b80\u6d01，\u8d8a\u590d\u6742\u7684\u6b63\u5219\u6027\u80fd\u8d8a\u5dee
\n\u6700\u540e\u7684\u5c0f\u63d0\u793a 💡
\n\u4ece\u7b80\u5355\u5f00\u59cb：\u4e0d\u8981\u4e00\u5f00\u59cb\u5c31\u5199\u590d\u6742\u7684\u6b63\u5219\u8868\u8fbe\u5f0f<\/p>\n

\u5584\u7528\u5de5\u5177：\u5728\u7ebf\u6d4b\u8bd5\u5de5\u5177\u80fd\u5927\u5927\u63d0\u9ad8\u6548\u7387<\/p>\n

\u5199\u597d\u6ce8\u91ca：\u590d\u6742\u7684\u6b63\u5219\u4e00\u5b9a\u8981\u5199\u6ce8\u91ca\u8bf4\u660e<\/p>\n

\u6027\u80fd\u76d1\u63a7：\u5728\u751f\u4ea7\u73af\u5883\u76d1\u63a7\u6b63\u5219\u67e5\u8be2\u7684\u6027\u80fd<\/p>\n

\u8bb0\u4f4f：\u6b63\u5219\u8868\u8fbe\u5f0f\u662f\u4e00\u95e8\u8bed\u8a00，\u9700\u8981\u4e0d\u65ad\u7ec3\u4e60\u624d\u80fd\u638c\u63e1\u3002\u5f00\u59cb\u53ef\u80fd\u4f1a\u89c9\u5f97\u7b26\u53f7\u5f88\u591a\u5f88\u96be\u8bb0，\u4f46\u53ea\u8981\u591a\u7ec3\u4e60，\u4f60\u4f1a\u53d1\u73b0\u5b83\u662f\u5904\u7406\u6587\u672c\u6570\u636e\u7684\u5f3a\u5927\u6b66\u5668！<\/p>\n

\u795d\u4f60\u5728\u6b63\u5219\u8868\u8fbe\u5f0f\u7684\u4e16\u754c\u91cc\u63a2\u7d22\u6109\u5feb，\u6210\u4e3a\u6570\u636e\u5904\u7406\u7684\u4e13\u5bb6！ 🚀<\/p>\n","protected":false},"excerpt":{"rendered":"

📖 \u524d\u8a00：\u4e3a\u4ec0\u4e48\u9700\u8981\u6b63\u5219\u8868\u8fbe\u5f0f？
\n\u5728\u65e5\u5e38\u5f00\u53d1\u4e2d，\u4f60\u662f\u5426\u9047\u5230\u8fc7\u8fd9\u6837\u7684\u70e6\u607c？
\n\u67e5\u627e\u6240\u6709\u4ee5\\”139\\”\u5f00\u5934\u7684\u624b\u673a\u53f7
\n\u9a8c\u8bc1\u90ae\u7bb1\u683c\u5f0f\u662f\u5426\u6b63\u786e
\n\u63d0\u53d6\u6587\u672c\u4e2d\u7684\u65e5\u671f\u4fe1\u606f
\n\u5339\u914d\u7279\u5b9a\u683c\u5f0f\u7684\u8eab\u4efd\u8bc1\u53f7
\n\u4f20\u7edf\u7684 LIKE \u64cd\u4f5c\u7b26\u5728\u8fd9\u4e9b\u590d\u6742\u573a\u666f\u4e0b\u529b\u4e0d\u4ece\u5fc3，\u800c\u6b63\u5219\u8868\u8fbe\u5f0f\u5c31\u662f\u89e3\u51b3\u8fd9\u4e9b\u95ee\u9898\u7684\u745e\u58eb\u519b\u5200！
\n🎯 \u7b2c\u4e00\u7ae0：\u6b63\u5219\u8868\u8fbe\u5f0f\u57fa\u7840\u5165\u95e8
\n1.1 \u4ec0\u4e48\u662f\u6b63\u5219\u8868\u8fbe\u5f0f？
\n\u6b63\u5219\u8868\u8fbe<\/p>\n","protected":false},"author":2,"featured_media":74501,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114,100,94],"topic":[],"class_list":["post-74505","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-mysql","tag-100","tag-94"],"yoast_head":"\nMySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/74505.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"📖 \u524d\u8a00：\u4e3a\u4ec0\u4e48\u9700\u8981\u6b63\u5219\u8868\u8fbe\u5f0f？ \u5728\u65e5\u5e38\u5f00\u53d1\u4e2d，\u4f60\u662f\u5426\u9047\u5230\u8fc7\u8fd9\u6837\u7684\u70e6\u607c？ \u67e5\u627e\u6240\u6709\u4ee5"139"\u5f00\u5934\u7684\u624b\u673a\u53f7 \u9a8c\u8bc1\u90ae\u7bb1\u683c\u5f0f\u662f\u5426\u6b63\u786e \u63d0\u53d6\u6587\u672c\u4e2d\u7684\u65e5\u671f\u4fe1\u606f \u5339\u914d\u7279\u5b9a\u683c\u5f0f\u7684\u8eab\u4efd\u8bc1\u53f7 \u4f20\u7edf\u7684 LIKE \u64cd\u4f5c\u7b26\u5728\u8fd9\u4e9b\u590d\u6742\u573a\u666f\u4e0b\u529b\u4e0d\u4ece\u5fc3，\u800c\u6b63\u5219\u8868\u8fbe\u5f0f\u5c31\u662f\u89e3\u51b3\u8fd9\u4e9b\u95ee\u9898\u7684\u745e\u58eb\u519b\u5200！ 🎯 \u7b2c\u4e00\u7ae0：\u6b63\u5219\u8868\u8fbe\u5f0f\u57fa\u7840\u5165\u95e8 1.1 \u4ec0\u4e48\u662f\u6b63\u5219\u8868\u8fbe\u5f0f？ \u6b63\u5219\u8868\u8fbe\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/74505.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-09T15:25:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260209152530-6989fc6a2120a.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/74505.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/74505.html\",\"name\":\"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-02-09T15:25:32+00:00\",\"dateModified\":\"2026-02-09T15:25:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/74505.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/74505.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/74505.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/74505.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"📖 \u524d\u8a00：\u4e3a\u4ec0\u4e48\u9700\u8981\u6b63\u5219\u8868\u8fbe\u5f0f？ \u5728\u65e5\u5e38\u5f00\u53d1\u4e2d，\u4f60\u662f\u5426\u9047\u5230\u8fc7\u8fd9\u6837\u7684\u70e6\u607c？ \u67e5\u627e\u6240\u6709\u4ee5\"139\"\u5f00\u5934\u7684\u624b\u673a\u53f7 \u9a8c\u8bc1\u90ae\u7bb1\u683c\u5f0f\u662f\u5426\u6b63\u786e \u63d0\u53d6\u6587\u672c\u4e2d\u7684\u65e5\u671f\u4fe1\u606f \u5339\u914d\u7279\u5b9a\u683c\u5f0f\u7684\u8eab\u4efd\u8bc1\u53f7 \u4f20\u7edf\u7684 LIKE \u64cd\u4f5c\u7b26\u5728\u8fd9\u4e9b\u590d\u6742\u573a\u666f\u4e0b\u529b\u4e0d\u4ece\u5fc3，\u800c\u6b63\u5219\u8868\u8fbe\u5f0f\u5c31\u662f\u89e3\u51b3\u8fd9\u4e9b\u95ee\u9898\u7684\u745e\u58eb\u519b\u5200！ 🎯 \u7b2c\u4e00\u7ae0：\u6b63\u5219\u8868\u8fbe\u5f0f\u57fa\u7840\u5165\u95e8 1.1 \u4ec0\u4e48\u662f\u6b63\u5219\u8868\u8fbe\u5f0f？ \u6b63\u5219\u8868\u8fbe","og_url":"https:\/\/www.wsisp.com\/helps\/74505.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-02-09T15:25:32+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260209152530-6989fc6a2120a.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/74505.html","url":"https:\/\/www.wsisp.com\/helps\/74505.html","name":"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-02-09T15:25:32+00:00","dateModified":"2026-02-09T15:25:32+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/74505.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/74505.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/74505.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL\u6b63\u5219\u8868\u8fbe\u5f0f\u6a21\u7cca\u67e5\u8be2\u5b8c\u5168\u6307\u5357\uff1a\u8ba9\u6570\u636e\u67e5\u627e\u66f4\u667a\u80fd"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/74505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=74505"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/74505\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/74501"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=74505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=74505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=74505"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=74505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}