本文介绍了MySQL查询从字段中提取第一个单词的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想运行一个查询,该查询仅从特定字段返回第一个单词,该字段具有多个由空格分隔的单词,我想我可能需要执行一些正则表达式工作来完成此操作?我知道如何使用PHP中的几种方法来执行此操作,但这最好在数据库端执行.任何想法表示赞赏.谢谢.
I would like to run a query that returns the first word only from a particular field, this field has multiple words separated by spaces, I assume I may need to carry out some regex work to accomplish this? I know how to do this using a few ways in PHP but this would best be carried out on the database side. Any ideas much appreciated. Thanks.
推荐答案SUBSTRING_INDEX: dev.mysql/doc/refman/5.0/zh-CN/string-functions.html#function_substring-index
SELECT SUBSTRING_INDEX(`name`, ' ', 1);更多推荐
MySQL查询从字段中提取第一个单词
发布评论