没有得到我的SQL中的大数据值 [英] Didn't get the large data value in my sql

问题描述

嗨..

我在我的sql中使用select查询获取大数据值时遇到问题。我有大数据值，因为我们给出一个空间值没有得到。当我在单词之间给出空格时如何获得价值



例如我通过搜索来获取价值的任务。

i给出这样的值任务类型可以是以下1. Bug 2.任务当用户输入任务时，让我们将任务类型默认选为bug

但是在数据库中它可以保存为

任务类型可以是以下

1.错误

2.任务

此外，当用户输入任务时，让我们将任务类型默认选为bug

，在这种情况下，当我通过编码值得到的值没有得到...我能做什么..请帮帮我..



提前谢谢..

hi..
i have a problem for getting large data value using select query in my sql. i have large data value in that we give one space value didn''t gets. how to get the value when i give the space between word to word

for example i do the task for get the value through searching.
i give the value like this "Task Type can be the following 1. Bug 2. Task Also when the user is entering the task, let us make the task type default selected to "bug" "
but in database it can be saved as
"Task Type can be the following
1. Bug
2. Task
Also when the user is entering the task, let us make the task type default selected to "bug" "
in this cases when i get the value through coding value didn''t gets.. what can i do.. please help me..

Thanks in advance..

推荐答案

有你试过这个问题吗？



试试喜欢 [ ^ ]运算符...

have you tried any query for this?

Try LIKE[^] operator in your query...

这篇关于没有得到我的SQL中的大数据值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！