find in set in laravel ? example

by

You need to escape the call to FIND_IN_SET() using quotes:

$query = DB::table('tags_value')
    ->whereRaw('FIND_IN_SET("css", Tags)')
    ->get();

But unless it’s a fixed value, you should always parameterize the column for which you search in FIND_IN_SET:

$searchvalue="css";
$query = DB::table('tags_value')
    ->whereRaw('FIND_IN_SET(?, Tags)', [$searchvalue])
    ->get();

More Related Contents:

  1. Laravel 5 PDOException Could Not Find Driver
  2. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  3. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  4. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  5. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  6. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  7. Laravel one to many relation with a one to one relation
  8. Laravel 5 – Remove Public from URL
  9. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  10. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  11. Trying to get Laravel 5 email to work
  12. Ajax post request in laravel 5 return error 500 (Internal Server Error)
  13. Access to Laravel 5 app locally from an external device
  14. Laravel Migration table already exists, but I want to add new not the older
  15. Script @php artisan package:discover handling the post-autoload-dump event returned with error code 255
  16. How can I paginate a merged collection in Laravel 5?
  17. ReflectionException: Class ClassName does not exist – Laravel
  18. Laravel 5.1: keep uploaded file as old input
  19. belongsToMany relationship in Laravel across multiple databases
  20. How to get client IP address in Laravel 5+
  21. Laravel Cannot delete or update a parent row: a foreign key constraint fails
  22. Base table or view not found: 1146 Table Laravel 5
  23. How to get MySql 8 to run with laravel? [duplicate]
  24. My Laravel 5.2.10 Sessions wont persist
  25. laravel 5 : Class ‘input’ not found
  26. Mysql InnoDB engine in Laravel
  27. Laravel changing timezone not reflecting the correct time
  28. How to remove /public/ from a Laravel URL
  29. Check if laravel model got saved or query got executed
  30. Unit Test Laravel’s FormRequest

Leave a Comment