You can use FIND_IN_SET():
WHERE FIND_IN_SET($sub_category, sub_category_id) > 0
laravel查询逗号分隔字符串的位置
Using Laravel to check if a value is in an array stored as comma delimited string, example string stored in mysql table 1,14,15,20,25
So I'm trying to add comma's at the start and end to search appropriately
$query = Profile::whereRaw("',' + cf_profile.sub_category_id + ',' LIKE '%,$sub_category->sub_category_id,%'");
Can anyone let me know where I'm going wrong here, as it's returning no results.
- 点赞
- 写回答
- 关注问题
- 收藏
- 复制链接分享
- 邀请回答
1条回答
-
采纳
点赞 评论 复制链接分享
提交
相关推荐
- 回答 1 已采纳 Using Laravel to check if a value is in an array stored as comma delimited string, example string stored in mysql table 1,14,15,20,25 So I'm trying to add comma's at the start and end to search appropriately $query = Profile::whereRaw("',' + cf_profile.sub_category_id + ',' LIKE '%,$sub_category->sub_category_id,%'"); Can anyone let me know where I'm going wrong here, as it's returning no results.
- 回答 1 已采纳 Just trying to do some tags validation. First checking for number of tags (as comma separated list of id's). class SomePostRequest extends Request { public function rules() { return [ 'tags' => 'between:2,5' ]; } public function all() { $input = parent::all(); $input['tags'] = explode(',', @$input['tags']); return $input; } } It keeps spititing out the message as The tags must be between 2 and 5 characters. Instead of the proper array message: The :attribute must have between :min and :max items.
- 回答 1 已采纳 So, basically I have a field in a table from my database which contains some values separated by comma (something like: value1, value2, value3). I need to check somehow if one or more of these values are contained in an array of values and retrieve the model(s). I'd like a solution using Eloquent Model Query to achieve this, if not possible with Model Query, then a Query Builder solution will be okay as well, or maybe something alternative.
- 2年前回答 2 已采纳 I want to separate my array into separate strings that all end with a comma. Array ( [0] => 233d3f9b-3e8e-4e16-ade2-6c165a0324c6 [2] => a6c736b0-f3d2-4907-9d36-6b31adeec2d1 [3] => 1e693cba-d0ce-4a24-bd75-b834e3f44272 ) The purpose of this is so i can pass it to an API. Like this 'optionUuids' => array( $options2, ), The option UUidds can contain multiple values as long its separated by a comma in the end. I tried solving my problem using implode. Implode adds a comma at the end of each line, but it treats this comma as a string. I want to have multiple option UUids so i would need commas that are actually commas and not strings. Im having trouble explaining this. This is what i expect: 'optionUuids' => array( 233d3f9b-3e8e-4e16-ade2-6c165a0324c6, a6c736b0-f3d2-4907-9d36-6b31adeec2d1, 1e693cba-d0ce-4a24-bd75-b834e3f44272, ),
- 3年前回答 1 已采纳 I have the following string $ickkcids = "120,176,182,120,182,207,176,120,182,118,120,176"; I want to display it in a ascending ordered, like below. 118(1) //118 is the lowest integer so it comes first. 120(4) 176(3) 182(3) 207(1) //207 is the highest integer so it comes last. This is what im doing $array = explode(',', $ickkcids); sort($array); foreach($array as $arraye) { $html .= $arraye.'<br />'; } But this returns all numbers in ascending order and i don't know how to count in this. Any idea how to achieve this?
- 回答 3 已采纳 只用包含来查是不行的， 例如我有一串字符串是 '1,3,0bc4a2f79a3e4ac09582d9c50f779630,ffe02ba8ca724ebe98f2a5f0b56d84a0'， 我希望能在我查找是否包含字符串时查找的是完全能在逗号分隔的字符串中找到对应， 例如我要找的是'1'，它查找到里面有'1'返回true， 我要找的是'2'，虽然长字符串里包含的有'2'，但因为没有在逗号分隔的字符串中找到完全对应的，所以返回的是false 希望各位大佬能帮帮忙
- 5年前回答 3 已采纳 There will be a string with a single or multiple with no commas at all. $str = "a, b"; How do I get the first value before the comma if it contains comma(s)? This is what I did. if(preg_match('/[,]+/', $str, $f)) { $firstVal = $f[0]; } NOTE: Is /^[^,]+/ better suited?
- 回答 3 已采纳 I have a array like that : $myarray= 'zzz,aaa,bbb' ; and want use it in mysql IN clause like that : "... WHERE ids IN ($myarray) " // didnt work "... WHERE ids IN ('$myarray') " // didnt work the error im getting is that the first value in that array zzz says that zzz is not a column name . so i understand that i must separate the values with quotes to be like that : $myarray= ' "zzz","aaa","bbb" ' ; But i have no clue to do that . any help would be much appreciated.
- 回答 2 已采纳 I have a problem with passing variable (data) to all Views. I created BaseController that extends default Laravel controller and "global" variables are defined there. When I extend other controller with BaseController i got error that variable is not defined. Does someone knows where's the problem? Here is code: namespace App\Http\Controllers; use App\Http\Requests; use App\Http\Controllers\Controller; use Sentry; use Illuminate\Http\Request; use View; class BaseController extends Controller { public function __construct() { $obavijesti="Other data"; $izbornici="Some data"; View::share ( 'izbornici', $izbornici ); View::share ( 'obavjesti', $obavjesti ); } } class AdminController extends BaseController { . . . echo '<pre>';var_dump($izbornici);echo '</pre>';//Error pop ups here . . . }
- 回答 1 已采纳 I'm trying to deepen my knowlade in laravel architecture. I have a search engine (elastic search for the sake of the example), but this search engine might change in the future. So im trying to write a container for this, so in case i'll change the engine in the future, i will have to change only the container. (I believe the termenology is factory design?) I have created a provider app/providers/DataFromSearchEngine.php that looks like this: use Illuminate\Support\ServiceProvider; class DataFromSearchEngine extends ServiceProvider { public function boot() { // } public function register() { $this->app->singleton('SearchEngine', function($app) { return new elasticSearch; }); } } Then i registered it in the providers array in config/app.php . 'providers' => [ // providers... 'App\Providers\DataFromSearchEngine' ], The next step is to call SearchEngine from my controller: namespace App\Http\Controllers; use App\Http\Requests; use App\Http\Controllers\Controller; use Illuminate\Http\Request; class SearchController extends Controller { protected $searchEngine; public function __construct() { $this->searchEngine = $this->app->make('SearchEngine'); } } But all these yields: Undefined property: App\Http\Controllers\SearchController::$app Can someone explain what i'm missing?
- 纳仁菜菜的博客 对文件而言，value是相应的文件字节数 max:value 验证字段必须小于等于最大值，和字符串、数值、文件字段的size规则一起使用 min:value 验证字段的最小值，对字符串、数值、文件字段而言，和size规则使用方式一致。...
- 顾米楠的博客 荆轲刺秦王 先看一下表结构： 最终结果要第一张表的数据，第一张表的data 中的字段对应的是 key,业务需要的是第二张表的 name 先看需要引入的文件：主要是model文件 ...use Illuminate\Support\Facades\DB;...
- 流浪者的短匕的博客 WHERE CONCAT(CONCAT(',', ID), ',') like CONCAT(CONCAT('%,', '1'), ',%') 解题思路，将字符串两边加上“,” 然后用like “%,1,%” 这种来匹配。
- 2年前宇学愈多的博客 有两个表，一个表记录了某些产品的公共信息，产品id用逗号分隔拼成字符串作为一个字段；一个表示产品表。如下： 公共信息表（info） id pro_ids num 1 12,14 10000.0 2 20,22 200000.0 ...
- weixin_39853210的博客 I am implementing a search using Laravel and Ajax. So I have a Product which belongs to a Tag and a Subcategory. On the other hand the Subcategory belongs to a Category. I want to check all of their p...
- 惊蛰ins的博客 首先观察下面的查询 ...现在我要根据另一张模板表中的一个字段查询他下面的公司，存的是字符串类型 这时 select * from company where f_id in (select company_id from templet where f_id=583) .
- 相对静止的博客 表1 表2 想要的结果 laravel框架： $res = $this->model ->leftJoin('tags as t',function ($join) { $join->whereRaw(\DB::raw('FIND_IN_SET(t.tag_id,artic...
- 月叾的博客 例如 字段值:1,11,12,2,21,22,3,31,32,33 需要查询的值: 3 查询所有 有3这个存在的数据 可以用到 FIND_IN_SET("3", 表中的字段名称) 来进行判断字段中是否存在3 ...
- 小筱萌的博客 public class StringSplitDemo { public static void main(String[] args) { String str="this,is,a,test"; String[] result=str.split(","); //split(正则表达式)
- 大强写代码的博客 废话不多说 直接上代码 ->where('FIND_IN_SET(:id,fid)',['id' =>...fid 是你数据库的以逗号分割的字符串的字段名 $id 是你要包含查询的值 打完收工》》》》》》》》》》》》》》》》》》》》